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 | |
| Cost of Revenue | 35,138,000.00 | |
| Total Revenue | 90,272,000.00 | |
| Cost of Revenue | 35,138,000.00 | |
| 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])