Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Remove Duplicates Based on Another Column Value

  Guys, I need your support please, I need to remove duplicates selecting 4 columns based on 5th column value condicationally:   The current script carries out removing the duplications of 4 selec...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Anonymous 

     

    You may check the steps in the pbix

     

     

    Best regards
    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

Fowmy's avatar
Fowmy
Super User
4 years ago

Anonymous 

Can you share/paste some sample data and show the expected output from Excel to correctly understand your question.?


  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Current dataset (2nd image)

    Desired output (1st image)

     

    • Fowmy's avatar
      Fowmy
      Super User
      4 years ago

      Anonymous 

      Do the following steps:

      1. Duplicate your source query
      2. Filter on one with Exception Type = Daily
      3. Apply Remove Duplicates on the table

      4. On the other copy of the query, filter out daily
      5. Append as New query

       

       

    • ronrsnfld's avatar
      ronrsnfld
      Super User
      4 years ago

      I'm looking at your top image as the desired output.  It seems to include duplicates (lines 2 and 3) as well as an Exception type of Monthly.  I thought you wanted those removed? Can you clarify?