Remove duplicates based on a condition in other columns

My data contains duplicates but there is a some difference in the data in the duplicate rows. I want to remove only selected rows based on the data in selected columns. eg. Column A is "reporting dis...

Need Help

Show and Tell

v-yingjl
4 years ago
Hi azmatkhan ,

Have created a table like this:

Set the filter condition:

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Remove duplicates based on a condition in other columns.pbix26 KB

Forum Discussion

Remove duplicates based on a condition in other columns

Related content

Merge duplicates data in columns

Column count duplicates

Duplicate ranking

Conditional Column with Multiple Conditions

Add duplicate row based on column