Forum Discussion
Still duplicates after removing duplicates
After removing duplicates there are still some duplicates remaining. The Table summary at the bottom of the table knows that there are duplicates as it says TABLE: Dimension_PF (63,036 rows) COLUMN: ...
Hello! Had the same issue.
What you need to do is add a Trim step before the Remove Duplicates in the Query Editor. It happens you can have "XYZ " (with blank spaces at the end) and "XYZ". PowerBi will count the as independent values. Trim function will eliminate those blank spaces at the end.
Best regards,
Cris
Thank you cam0082. I was struggling with this issue for a long time. Never occurred to me that this might be the case