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