Remove Duplicate Rows in Query Editor

[venug20]

Hi Everyone,

i have data like below...

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

Data Level	District	Sales Value	Customer id
District level	Bagpat	1037764.267	0
District level	Bagpat	1037764.267	0
District level	Bagpat	1037764.267	0
District level	Bijnor	1037764.267	0
District level	Bijnor	1037764.267	0
District level	Bijnor	1037764.267	0
District level	Bijnor	1037764.267	0
State level	Agra	1037764.267	0
State level	Agra	1037764.267	0
State level	Agra	1037764.267	0
State level	Aligarh	1037764.267	0
State level	Allahabad	1037764.267	0
State level	Allahabad	1037764.267	0
State level	Allahabad	1037764.267	0
State level	Allahabad	1504302.69	29
District level	Allahabad	1504302.69	29
State level	Ambedkar Nagar	1037764.267	0
State level	Amethi	97057.16667	30
District level	Amethi	97057.16667	30
State level	Bahraich	995953.1667	21
District level	Bahraich	995953.1667	21
State level	Budaun	2846124.41	23
District level	Budaun	2846124.41	23
State level	Ghazipur	408607.1667	27
District level	Ghazipur	408607.1667	27
State level	Hardoi	1676610.35	24
District level	Hardoi	1676610.35	24
State level	Pratapgarh	1534924.017	22
District level	Pratapgarh	1534924.017	22

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

[Anonymous]

Hi @venug20,

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

Br,

T

[venug20]

@Anonymous

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

[Anonymous · Accepted solution]

@venug20

Heres a PBIX: Duplicate removal

See the "Removed Duplicates" table in the query editor

Br,

T

[venug20]

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

[cnschulz]

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

Always the first row gets removed

[abeggmi]

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