Forum Discussion
Solved
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 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...
7 Replies
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
Anonymous
I am not able get correct output after remove duplicates. Pls share PBIX file using my sample data if possible...
