Forum Discussion
pbi_106
Helper I
5 years agoCasing on text fields doesn't always match the data
I'm running into a strange issue. After adding a new column to an existing table within my report through the Power Query Editor's Source window (I tweaked the "SQL statement" box to add the new col...
Syndicate_Admin
Administrator
3 years ago
"The problem is that DAX is not case sensitive, so if you have multiple text strings in a column that only differ on a case-by-case basis, the engine will choose one of them as a representative of all of them."