Forum Discussion

PowerBIspeed's avatar
PowerBIspeed
Frequent Visitor
4 years ago
Solved

Remove rows based different columns

Hi,   I have a table with a lot off records(rows) which have to removed or filterd from the table based on 3 colums. Example: There are two records where column A, B and C are equal, then they ha...
Need Help
  • tackytechtom's avatar
    tackytechtom
    4 years ago

    Hi PowerBIspeed ,

     

    If you'd like to remove all rows that exist more than once, here another approach:

     

    Select all columns you'd like to check for duplicates, right click and click Group By:

     

     

    Choose the following settings:

     

     

    Then filter for the ones that are lower than 2:

     

     

    The result:

     

     

    Let me know if this helps 🙂

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/