Forum Discussion
In Power Query Editor, how to remove the duplicates while also removing the original
For that, you need to do an extra thing.
In step 1 of grouping, go to Advance section and add an aggregation to get all rows. Something like this:
2) Then filter out the rows having Duplicates count as 1 as below:
3) Then expand other columns as below:
The end output will give you all your required columns.
you have to ways
1) select the column, right click on the column that have the refered duplicate and look for the remove duplicate option, have done it and works if isnt working for you would be very strange
2) if all row of each duplicate its the same, go to the main tabs and choose under the rows deletion options the delete duplicate rows.
for a better insight share the M code of how you trying the remove duplicate step to see where its failing.
StefanoGrimaldi , thank you for your reply.
but your way can only help to remove the duplicated one, I also need to remove the original one.Anonymous If the only instances you want to delete are the ones visible in the screenshot, you might just filter out the rows that you do not want, using the 'identifier' column.
P.S. The last red brackets in the picture aren't actually duplicates 🙂
thank you for your reply!
Unfortunately, I really need to filter those rows out programatically. Those red lines are the rows that our shippers ship by mistake.
Do you know other solutions ?
