Remove Duplicates but with certain criteria

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!