Remove Duplicates but with certain criteria

[johnphil]

Just starting out with Power Query.

Is there a way to apply "Remove Duplicates" functionality to data belonging in the same period only (e.g. month/year) or a certain criteria?

The setup is to use Power Query to extract info from a specific folder where the monthly files are being saved.

I tried using the "Remove Duplicates" but it also deletes the same data/row coming from the other months. Is there a way to define or to limit that function? Thanks!

[danextian · Accepted solution]

Hi @johnphil,

You may actually include more than one column in removing duplicates. Have tried selecting Month, Name and Country before deduping your table?

[johnphil]

many thanks @danextian. i didnt know it was that simple.