Forum Discussion
remove duplicates per year
I have a data set where that i want to filter out duplicate entries per year. Tried looking on here and doing group by, got an error during the process.
Table audit test
ICN Year
V1234 2019
V1234 2020
V1234 2020
V1234 2021
V2345 2019
V2345 2019
V2345 2020
want
V1234 2019
V1234 2020
V1234 2021
V2345 1029
V2345 2020
Hey nerdyplayer
It is actually much simpler than you might have anticipated.
If I have understood your requirement correctly, all you need to do is select both columns, namely "ICN" and "Year," then right-click and choose "Remove Duplicates." You can select multiple columns by holding down the CTRL key.
Here is the sample GIF for your referece:
Best Regards,
Udit
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍
🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree
Proud to be a Super User
2 Replies
Hey nerdyplayer
It is actually much simpler than you might have anticipated.
If I have understood your requirement correctly, all you need to do is select both columns, namely "ICN" and "Year," then right-click and choose "Remove Duplicates." You can select multiple columns by holding down the CTRL key.
Here is the sample GIF for your referece:
Best Regards,
Udit
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍
🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree
Proud to be a Super UserHi nerdyplayer create a custom column
= Text.From([ICN]) & "-" & Text.From([Year])
and then use remove rows>remove duplicates in this new column
