Forum Discussion
Remove Specific Duplicate Row
Anonymous , You can use remove duplicate in Edit query/data transformation
https://radacad.com/remove-duplicate-doesnt-work-in-power-query-for-power-bi-here-is-the-solution
Another option is that you create a new table using summarize like
summarize(Table,Table[ID],"Status",max(Table[Status]), "Value",min(Table[Value]))
Add remove columns as per need.
Hi amitchandak
That article doesn't mention anything about removing select duplicates based on values in another column.
Summarize wouldn't work, I need to do this in Power Query because there are a lot more data transformations to do afterwards.
Could you not do it in two steps - before you remove duplicates, make some sort of calculated column that counts the instances of that row's value in the column you're doing the dupe check on, then make a conditional column that sees if the new column's more than 1 and your status is inactive, and use that to delete your inactive dupes first? Not particularly efficient, but it should work
edit - probably need to add in some condition to consider the situation where there's two rows and they're both inactive, but the general principle is the same
