NEW! FREE 90 Minutes Excel VBA Course for Beginners! Watch now 

Power BITutorials

Read How to Remove Duplicates Using Power Query

1 Mins read

Power Query cannot only keep duplicate records but also can remove the duplicate data. The advantage of this feature is that it removes the human error whenever you try to delete your duplicate data manually.

Remove Duplicates by Power Query

Suppose you have this set of data. As you can see the marked ones are duplicate values, why not get rid of them!

 

Step 1: Load the data in Power Query and note the duplicate data

As shown in the below picture, there are few duplicate row items that are highlighted.

DATA TABLE BEFORE REMOVING DUPLICATES

Step 2: Remove Duplicate Rows

To remove the duplicate rows, go to

Home > Remove Rows button > Remove Duplicates option

REMOVE DUPLICATE DATA

Step 3: Save and Close

After you get the expected result, just click on the save icon to save and Close and Apply button to close the Query Editor.

 

DATA TABLE AFTER REMOVING DUPLICATES

You can learn more :

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…