Forum Discussion
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 have to be removed or filterd out.
Is this possible ?
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/
6 Replies
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/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 ,
Ok, how about this:
After:
Mark all the column you wish to check for duplicates. Then right click and click on remove duplicates:
Note, this approach does onoy remove one of the duplicates
Let me know if this solves your issue 🙂
/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.
