Power Query - Join a Table based on a Date Range 😎😶🌫️
Рет қаралды 1,246
29 күн бұрын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...
@alexrosen8762 25 күн бұрын
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 👌🙏👌
@SndfOmar 23 күн бұрын
Awesome & Brilliant! Thanks.
@rlds07 27 күн бұрын
Very good!
@kebincui 25 күн бұрын
Excellent as always👍
@itslester 26 күн бұрын
Very very cool!
@aart_analyst 26 күн бұрын
Loving your videos. Keep it up, you're doing a great job at making the M Language more understandable.
@DinoAMAntunes 27 күн бұрын
🤟please more with Outer and inner videos
@williamarthur4801 25 күн бұрын
I use it a lot, you may have already seen it but Mike Girvin's MSPTDA series covers it.
@boissierepascal5755 27 күн бұрын
🎉🎉🎉
@SamehRSameh 25 күн бұрын
Which table is inner table ?
@MrJamesbotes 24 күн бұрын
The broker table is the inner table that is represented by a table for each row of the trade table
Gufee.medalin
Рет қаралды 9 МЛН
Gyanbar
Рет қаралды 112 М.