Forum Discussion

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
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/

PowerBIspeed

Frequent Visitor

4 years ago

Sorry, my mistake but I explained it wrong.

I want to remove the record where Column A in record 1 and 2 are equal, Column Bin record 1 and 2 are equal and Column c in record 1 and 2 are equal. when in both records the all the 3 Columns are Equal remove the records