Removing Duplicate Rows in Power BI

Duplicate rows can be removed both using Query Editor and DAX

We will use this simple data

ITEMS Amount ENTITY
Total Revenue      90,272,000.00 GOOGLE
Cost of Revenue      35,138,000.00 GOOGLE
Total Revenue      90,272,000.00 GOOGLE
Cost of Revenue      35,138,000.00 GOOGLE
Total Revenue   215,639,000.00 APPLE
Cost of Revenue   131,376,000.00 APPLE
Total Revenue   215,639,000.00 APPLE
Cost of Revenue   131,376,000.00 APPLE

USING QUERY EDITOR / POWER QUERY

After loading your Table…..Select all the Columns>>>Go to Home Tab >>>Remove Rows>>>Remove Duplicates

USING DAX CALCULATED TABLE

We can create a Calculated Table which removes the Duplicates.

Go to Modelling Tab>>>NEW TABLE and use the following formula

New Table = DISTINCT(TableName)

Also instead of DISTINCT we can use the ALL function, since ALL returns the Unique combination of Columns passed as arguments i.e.

Table = All(TableName[ENTITY],TableName[ITEMS],TableName[Amount])

 

Share This: