Remove rows based different columns

[PowerBIspeed]

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 ?

[PowerBIspeed]

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

[tackytechtom · Accepted solution]

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]

Hi Tom,

This solution worked for me. Thanks a lot.

[tackytechtom]

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/

[tackytechtom]

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/

[PC2790]

Hey @PowerBIspeed ,

See if this thread caters to your requirement.