cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
johnphil Frequent Visitor
Frequent Visitor

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!

 

Capture.JPG

 

Capture1.JPG

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
danextian New Contributor
New Contributor

Re: Remove Duplicates but with certain criteria

Hi @johnphil,

 

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

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa
2 REPLIES 2
danextian New Contributor
New Contributor

Re: Remove Duplicates but with certain criteria

Hi @johnphil,

 

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

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa
johnphil Frequent Visitor
Frequent Visitor

Re: Remove Duplicates but with certain criteria

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