Changing the ID letter case after loading into model

Hi Anonymous ,

I created a test table as follows：

Although the software is case sensitive in the power query, but in data view, the software isn't case sensitive when the value is exactly the same except for the case. In other words, DAX is not case sensitive.

For your Problem, it has been mentioned many times in the forum, maybe you can refer other answers:

Creating Case Sensitive Table Relationships  

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.