Forum Discussion

snow87's avatar
snow87
Icon for Helper I rankHelper I
3 years ago

Duplicate only in report/service

Hi have a dataset where 14 rows have the value IF in the Clarity column. In the desktop app, in the power query interface or the dax interface these show up as the same value.   They even have the ...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
3 years ago

Hi snow87 

 

In Power Query the data is case sensitive, so you have to make sure that the text has the exact upper and lower case spelling. If they are different it will be treated as different values.

  • snow87's avatar
    snow87
    Icon for Helper I rankHelper I
    3 years ago

    They're all all caps