Forum Discussion
rbowen
Helper III
Helper IIIBI 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
Community Champion
Community Championrbowen In short, yes. I demonstrate the technique in this video:
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 :
- Greg_Deckler
Florisz UNICHAR is a DAX funtion. In M you would need to use Character.FromNumber