Forum Discussion
Remove Duplicates not working in power query
Hello, I am not able to remove duplicates from an insured name column. I have tried clean and trim. Checked by loading it to excel as i was not able to create relationships in DAX, I see that thi...
Hi Anonymous ,
When there're only two column in your table, you can successfully remove duplicates.
It removes duplicate rows based on the removal of an entire row, not a column of duplicate rows.
For example, in the following data, if you want to remove duplicate rows in the Insured Name column.
Here's the solution.
1.Group by.
2.Add an index column.
3.Expand it and filter 1.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.