Power BI
Sep 16, 2022 12:00 AM
Power Query Challenge - Creating a Merge Duplicates Alert
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/
More about Power BI
HubSite 365 Apps
We value your privacy
This website stores data such as cookies to enable important website functions as well as marketing, personalization and analysis. You can change your settings at any time or accept the default settings. privacy policy.