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/

     

tackytechtom's avatar
tackytechtom
Most Valuable Professional
4 years ago

Hi PowerBIspeed ,

 

In Power Query, you could create an additional column with all your filter requirements. Here an example of filtering all the rows that have the same value in all three columns:

 

Create a new column:

 

 

Filter out all the ones that have 1 in the new column:

 

Done:

 

Let me know if this helps 🙂

 

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