Power Query - Join a Table based on a Date Range 😎😶🌫️
In this Video is show you how to join a 2 tables based on a date range. You'll learn how to join a inner and a outer table within one Query. #OuterInnerTable #powerbi #mquery #powerbidesktop #data #dataanalytics #excel.
The File
github.com/jbotes/powerbiTuto...
Links to Functions used
table.AddColumn
powerquery.how/table-addcolumn/
Table.SelectRows
powerquery.how/table-selectrows/
Table.ExpandTableColumn
powerquery.how/table-expandta...
Пікірлер: 12
Excellent and a very useful tutorial since the example has many use cases in real life. Your tutorials always teches me something new. No exception this time 👌🙏👌
Awesome & Brilliant! Thanks.
Loving your videos. Keep it up, you're doing a great job at making the M Language more understandable.
Excellent as always👍
Very very cool!
🤟please more with Outer and inner videos
@williamarthur4801
Ай бұрын
I use it a lot, you may have already seen it but Mike Girvin's MSPTDA series covers it.
Excellent! Most solutions out there start with a merge query which might not be applicable when there is no common column between the two tables.
Very good!
🎉🎉🎉
Which table is inner table ?
@MrJamesbotes
Ай бұрын
The broker table is the inner table that is represented by a table for each row of the trade table