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
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")