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 ...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

ImkeF and Anonymous my apology for the late reply.

 

I tried ImkeF method it still doesnt work however I tried the "grouped by" function in "transform" tab and it works.

 

Just extra step.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Problem is, that Power BI has two different ways of handling data in two different situations.

 

1. Remove duplicates in Query Editor - it IS case sensitive, eg. "EMPLOYER" and "employer" are two different strings (are not duplicates)

2. Building a relation - it IS NOT case sensitive, eg. "EMPLOYER" and "employer" are the same strings (are duplicates), therefore I can't build a relation

 

Microsoft, please, fix this "feature" it is really annoying. Work with data one way in the application.