Forum Discussion

PascalvanDongen's avatar
PascalvanDongen
New Member
3 years ago
Solved

Query for unique values in two columns.

Hello everyone!   I am relatively new to Power BI, specifically to using Power Query. I have multiple source files, which all use a certain code to distinguish certain budgets. These codes have a s...
  • vanessafvg's avatar
    3 years ago

    you mean like this?

     

    1. Remove the amount column

    2.  highlight both columns and right click remove duplicates.

     

    see attached.

     

    but there are various ways, this is just one way.