Forum Discussion
stokercw
8 years agoNew Member
Table visualization and case sensitivity
Why does Power BI Desktop change case? My data is case-sensitive: DATABASE_NAME ARCHIVED_DATE ---------------------------------------------------...
- 8 years ago
Happy New Years Day!
Add custom column, not conditional column.
Conditional Column options are too basic to handle List.Contains or invisible characters.
Then paste into the custom column window:
if List.Contains(List.Transform({97..122}, each Character.FromNumber(_)), Text.Start([DATABASE_NAME], 1)) then Character.FromNumber(8236) else ""
I'm assuming your column is named [DATABASE_NAME], but if not, then substitute the right name.
Basically...
List.Contains({a..z}, "e" is true.
List.Contains({a..z}, "E" is false.Fred
vijay_kolisetty
8 years agoFrequent Visitor
Hi
I think its treating the first values format with the second value. You can post your query in Power BI idea forum to make a glance to the respective people.
Regards,
Vijay