Forum Discussion

johnphil's avatar
johnphil
Regular Visitor
8 years ago
Solved

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 u...
Need Help
  • danextian's avatar
    danextian
    8 years ago

    Hi johnphil,

     

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

danextian's avatar
danextian
Icon for Super User rankSuper User
8 years ago

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's avatar
johnphil
Regular Visitor
8 years ago

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