Forum Discussion
Still duplicates after removing duplicates
Yes I've experienced that before which is something I always check for but on this occasion with this data there are no blanks or null values. As previously mentioned even after the remove duplicate step, the counts at the bottom or the table when selecting the column still recognises that there are duplicates i.e. TABLE:.... (63,036 rows) COLUMN (63,034 distinct values)
Confusing to say the least.
I'll locate them manually and just remove I think!
Hi terrells,
Please check if the column "Public Folder Path" contains uppercase or lowercase for the same character, for example, the column has two values "A" and "a", it will be treat as distinct value. While after loading to data model, those two characters will be treat as the same character (based on my test, it's "A").
Best Regards,
Qiuyun Yu
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
This worked for me. Thank you so much
Thank you cam0082. I was struggling with this issue for a long time. Never occurred to me that this might be the case
