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

     

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.

       

      • abeggmi's avatar
        abeggmi
        Regular Visitor
        5 years ago

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