Removing rows based on a set of conditions

[jleibowitz]

I am trying to remove rows of data that show duplicate information. However, the rows I would like to remove would need to be based on a set of conditions. For example, I have a set of customer data and would like for duplicates to be removed if the customer full name AND the customer address are both the same. I know you can remove rows in query editor but from the looks of it you can only remove duplicates based on a single column and that would not work. Thanks!

[jleibowitz]

Thank you for the the help. All solutions worked and are used in different scenarios.

[Hasan · Accepted solution]

You can select the multible colums in Query Editor mode and remove the dblicates also

[Greg_Deckler]

Create a new column that concatenates your two columns, use that to remove duplicates.

[Joak]

This doesn't work for me as what I have to concatenate is a date (24/07/2017) a number (1234) and a town (London) 

It works in dax but doesn't in power query

[vanessafvg]

@jleibowitz you can highlight the columns you want to remove duplicates, right click and boom  remove duplicates in M (power query)