Sep 16, 2022 12:00 AM

Power Query Challenge - Creating a Merge Duplicates Alert

External YouTube Channel

I showed a risk that duplicates in your merged "lookup / dimension" table can result in doubling your data by Access Analytic

XLOOKUP v Power Query v Power Pivot in Excel

When combining tables in Excel there are several options.

Here I show you XLOOKUP, Power Query Merge and a Power Pivot relationship.

https://www.youtube.com/watch?v=KdF-OQ8G5FY&t=0s

A twist to turn Keep Duplicates into Keep Unique in #PowerQuery

In Power Query Editor, there is a button of “Keep Duplicates” in the ribbon. It’s located under Keep Rows in the section of Reduce Rows in the Home tab of the ribbon.

https://wmfexcel.com/2022/04/07/a-twist-to-turn-keep-duplicates-into-keep-unique-in-powerquery/