Forum Discussion
Remove rows based different columns
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/
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
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/
Hi Tom,
This solution worked for me. Thanks a lot.