cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: Remove Duplicate Rows in Query Editor

@venug20

 

Heres a PBIX: Duplicate removal

See the "Removed Duplicates" table in the query editor

 

Br,

T

 

View solution in original post

5 REPLIES 5
Highlighted
Anonymous
Not applicable

Re: Remove Duplicate Rows in Query Editor

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

 

 

Highlighted
Resolver I
Resolver I

Re: Remove Duplicate Rows in Query Editor

@Anonymous

 

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

Highlighted
Anonymous
Not applicable

Re: Remove Duplicate Rows in Query Editor

@venug20

 

Heres a PBIX: Duplicate removal

See the "Removed Duplicates" table in the query editor

 

Br,

T

 

View solution in original post

Highlighted
Resolver I
Resolver I

Re: Remove Duplicate Rows in Query Editor

@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....

 

 

Highlighted
Helper IV
Helper IV

Re: Remove Duplicate Rows in Query Editor

@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.

 

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors