Forum Discussion

venug20's avatar
venug20
Icon for Resolver I rankResolver I
8 years ago
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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    venug20

     

    Heres a PBIX: Duplicate removal

    See the "Removed Duplicates" table in the query editor

     

    Br,

    T

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
venug20
Icon for Resolver I rankResolver I
8 years ago

Anonymous

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    venug20

     

    Heres a PBIX: Duplicate removal

    See the "Removed Duplicates" table in the query editor

     

    Br,

    T

     

    • venug20's avatar
      venug20
      Icon for Resolver I rankResolver I
      8 years ago

      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's avatar
        cnschulz
        Icon for Helper IV rankHelper IV
        7 years ago

        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.