cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
venug20
Resolver I
Resolver I

Remove Duplicate Rows in Query Editor

Hi Everyone,

 

i have data like below...

 

I want to remove duplicate row "Data level & District & Cust ID"....

 

 

Data LevelDistrictSales ValueCustomer id
District levelBagpat1037764.2670
District levelBagpat1037764.2670
District levelBagpat1037764.2670
District levelBijnor1037764.2670
District levelBijnor1037764.2670
District levelBijnor1037764.2670
District levelBijnor1037764.2670
State levelAgra1037764.2670
State levelAgra1037764.2670
State levelAgra1037764.2670
State levelAligarh1037764.2670
State levelAllahabad1037764.2670
State levelAllahabad1037764.2670
State levelAllahabad1037764.2670
State levelAllahabad1504302.6929
District levelAllahabad1504302.6929
State levelAmbedkar Nagar1037764.2670
State levelAmethi97057.1666730
District levelAmethi97057.1666730
State levelBahraich995953.166721
District levelBahraich995953.166721
State levelBudaun2846124.4123
District levelBudaun2846124.4123
State levelGhazipur408607.166727
District levelGhazipur408607.166727
State levelHardoi1676610.3524
District levelHardoi1676610.3524
State levelPratapgarh1534924.01722
District levelPratapgarh1534924.01722

 

Pls provide solution to this data.... Thanks in advance...

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@venug20

 

Heres a PBIX: Duplicate removal

See the "Removed Duplicates" table in the query editor

 

Br,

T

 

View solution in original post

7 REPLIES 7
Anonymous
Not applicable

Hi @venug20,

 

Select all columns in question and then right click one of them. Then select Remove Duplicates and that should do the trick.Duplicates.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Br,

T

 

 

@Anonymous

 

I am not able get correct output after remove duplicates. Pls share PBIX file using my sample data if possible...

Anonymous
Not applicable

@venug20

 

Heres a PBIX: Duplicate removal

See the "Removed Duplicates" table in the query editor

 

Br,

T

 

@Anonymous

 

thanks for your solution...

 

I have one doubt,

 

i want to remove duplicate where id = 0, when remaining id also having duplicate.

 

is there any solution for this query....

 

 

@venug20 I am after the same thing.

 

How does the process decide *which* row to delete based on the duplicate colums? I want to ensure it deletes the right one based on the quality ranking I have given the records.

 

charleshale
Responsive Resident
Responsive Resident

Always the first row gets removed

Hi
I'm looking for precisely this question - how to decite which of the duplicates should be removed?

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!