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)
I'm looking at your top image as the desired output. It seems to include duplicates (lines 2 and 3) as well as an Exception type of Monthly. I thought you wanted those removed? Can you clarify?