Forum Discussion

clarainesgg's avatar
clarainesgg
Icon for Helper I rankHelper I
2 years ago

Remove Duplicates based on all the tables

Hi,

 

 

I need to remove duplicates for the entire table as in Excel. Is it possible? I tried removed duplicates, selecting the entire table

 

 

 

Hower, then it shows in red.

 

Also is it possible to see which duplicates the query delete?

 

Thanks,

 

Clara

Need Help
Show and Tell

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    clarainesgg If you select the first column, hold down shift and select the last column and then right-click and remove duplicates, it should remove duplicate rows. I don't believe it is possible to see which duplicates the query removed. The step in Advanced Editor is:

     

    #"Removed Duplicates" = Table.Distinct(#"Changed Type")

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thanks for Greg_Deckler 's reply.
    Hi clarainesgg ,

    Are there any duplicate rows in your table?

     

    If the table does not have any duplicate rows, whether you use Remove Duplicates in Power Query to de-duplicate the entire table or DAX: DISTINCT(Table).
    Neither of these will work.


    Best Regards,
    Dengliang Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.