remove duplicates per year

[nerdyplayer]

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

[techies]

Hi @nerdyplayer create a custom column

= Text.From([ICN]) & "-" & Text.From([Year])

and then use remove rows>remove  duplicates in this new column

[quantumudit · Accepted solution]

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