Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

"Remove Duplicate" doesn't remove all duplicate

Dear all,   I have a table with just one column, I tried to remove the duplicate in the column via power query. However, once I loaded to the dashboard I use count and count(distinct) both give me ...
LarsSchreiber's avatar
LarsSchreiber
Icon for Responsive Resident rankResponsive Resident
9 years ago

Hey Anonymous@

 

I wrote a post already in February about the different understanding of duplicates of Power Query and Power Pivot here, but ImkeFs idea of using the Comparer.OrdialIgnoreCase porperty is great and simple. 

 

 

Thanks a lot :-)