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.

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.