Power Query Merge Challenge Solution - Duplicates Alert
Merging tables in Power Query can be risky, so here's a way to add a warning to your output table
Merging with date range using Power Query
In this blog, we will see how to merge two tables in Power Query based on key column and a date range.
https://exceed.hr/blog/merging-with-date-range-using-power-query/
Optimising The Performance Of Power Query Merges In Power BI, Part 3: Table.Join And SortMerge
In the last two posts in this series I showed how removing columns from the tables used in a Power Query merge operation can improve refresh performance. In this post I’ll show you a different trick that – when you can use it – can give you an equally significant performance boost.
How To Dynamically Merge Columns In A Power Query Table
In this tutorial, we’ll examine an interesting question that was raised on the Enterprise DNA Forum about how to dynamically merge a changing number of columns in a Power Query table. You can watch the full video of this tutorial at the bottom of this blog.
https://blog.enterprisedna.co/power-query-table-how-to-dynamically-merge-columns/