Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
You can select the multible colums in Query Editor mode and remove the dblicates also
Thank you for the the help. All solutions worked and are used in different scenarios.
You can select the multible colums in Query Editor mode and remove the dblicates also
Create a new column that concatenates your two columns, use that to remove duplicates.
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
@jleibowitz you can highlight the columns you want to remove duplicates, right click and boom remove duplicates in M (power query)
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |