Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

 

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors