Forum Discussion
Selectively remove duplicate rows?
In the query editor, there is a function which allows a developer to remove duplicate rows based on the selected columns. I want to add an additional condition to this. That is, I want to choose...
Power Query, if I'm reading my own pbix right where I have a similar situation (have appended a new report to an old one, and if there's a matching case number I want to keep the data from the new report), removes duplicates from the bottom up - if you make a custom column that gives anything that's type A the value 1, and type B the value 2, then sort ascending on the new column, this should force it to remove the rows you want
Thank you MarcelBeug for the knowledge sharing. I'll include the step to buffer the table prior to removing duplicates.
Kudos.
IMHO the anti-join is the way to go here. I never like sorting and relying on some undocumented logic to always work or not change in the future.