Thank you Isabella Chen!! I have updated the name now. You can definitely use the #shared method to find particular table and merge. Remember, most dynamic query has a cost, i.e. the performance if it didn't applies properly.
@@bsmart2gether408 Thant right. I would like to know a more efficient way to merge compared to the traditional method which always result in poor performance of the model.
Chris Web (one of the best blogger) suggested that Table.Join and I use Table.Join most of the time to optimise queries. One catch is good data structure required as Table.Join return everything where Table.NestedJoin stored data in the memory. blog.crossjoin.co.uk/2020/06/07/optimising-the-performance-of-power-query-merges-in-power-bi-part-3-table-join-and-sortmerge/
super, your videos are truly something else, thanks
Thank you Stefano 😊
Excellent...this is next level power query :) unique and interesting solution.
Thank you Sumanth. This is KT style 😁
Thank you so much!!!Video is really informative
Hi anand, I how this help and addressed your challenges.
Great channel!
Thank you Alex
That’s great content! Is there an efficient way to merge multiple tables together? BTW you forgot to update the video name 😅
Thank you Isabella Chen!! I have updated the name now. You can definitely use the #shared method to find particular table and merge. Remember, most dynamic query has a cost, i.e. the performance if it didn't applies properly.
@@bsmart2gether408 Thant right. I would like to know a more efficient way to merge compared to the traditional method which always result in poor performance of the model.
Chris Web (one of the best blogger) suggested that Table.Join and I use Table.Join most of the time to optimise queries. One catch is good data structure required as Table.Join return everything where Table.NestedJoin stored data in the memory. blog.crossjoin.co.uk/2020/06/07/optimising-the-performance-of-power-query-merges-in-power-bi-part-3-table-join-and-sortmerge/