Power Query - Join a Table based on a Date Range ‍️

Power Query - Join a Table based on a Date Range ‍️

BA Sensei

54 года назад

2,729 Просмотров

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
https://github.com/jbotes/powerbiTutorials/blob/main/Trades_video.xlsx

Links to Functions used
table.AddColumn
https://powerquery.how/table-addcolumn/
Table.SelectRows
https://powerquery.how/table-selectrows/
Table.ExpandTableColumn
https://powerquery.how/table-expandtablecolumn/
Ссылки и html тэги не поддерживаются


Комментарии: