Power Query Merge Challenge Solution - Duplicates Alert
Oct 4, 2022 12:00 AM

Power Query Merge Challenge Solution - Duplicates Alert

External YouTube Channel

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.


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.