Forum Discussion
Remove Duplicates Based on Another Column Value
Guys, I need your support please, I need to remove duplicates selecting 4 columns based on 5th column value condicationally: The current script carries out removing the duplications of 4 selec...
Anonymous
You may check the steps in the pbix
Best regards
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Current dataset (2nd image)
Desired output (1st image)
Anonymous
Do the following steps:
1. Duplicate your source query
2. Filter on one with Exception Type = Daily
3. Apply Remove Duplicates on the table
4. On the other copy of the query, filter out daily
5. Append as New query