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/jbo...
Links to Functions used
table.AddColumn
powerquery.how...
Table.SelectRows
powerquery.how...
Table.ExpandTableColumn
powerquery.how...

[@alexrosen8762]

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 👌🙏👌

[@trustnoone6065]

Waiting for this case scenario for long. Thanks a lot

[@SndfOmar]

Awesome & Brilliant!
Thanks.

[@kebincui]

Excellent as always👍

[@DinoAMAntunes]

🤟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.

[@aart_analyst]

Loving your videos. Keep it up, you're doing a great job at making the M Language more understandable.

[@jericsayoc9579]

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.

[@rlds07]

Very good!

[@boissierepascal5755]

🎉🎉🎉

[@itslester]

Very very cool!

[@SamehRSameh]

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