Forum Discussion
Solved
BI Desktop Not Recognizing Difference Between Upper and Lower Case Letters
Greetings All - I'm working with a data table containing some account information. Part of that information is account codes that contain a main account number, and a sub account number. The sub...
oh my bad here use this https://invisibletext.com/
insetead of the u+200e just copy this text in this link
Greg_Deckler , I like your video. Tried to solve it your way, but throws me an error, that I don't find searching the web...
=if Text.StartsWith([Data], Text.Lower(Text.Start([Data], 1))) then [Data] & UNICHAR(8203) else [Data]
Expression.Error: The name 'UNICHAR' wasn't recognized :
Florisz UNICHAR is a DAX funtion. In M you would need to use Character.FromNumber