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 i...
Need Help
Show and Tell
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.