Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Is there an existing function to check whether a text is in upper or lower case or do i still need to create a custom function?
Proud to be a Super User!
Solved! Go to Solution.
No. You can create a custom function using Text.Lower and/or Text.Upper, like:
(Text as text) as logical => let IsTextAllUpperCase = Text.Upper(Text) = Text in IsTextAllUpperCase
You could compare the string with the result of UPPER() on that string.
You must use the EXACT() function for this:
IsUpperCase = IF(EXACT(UPPER(data[string]), data[string]), TRUE(), FALSE())
On a side note, I just noticed a bug with the Enter Data option (if you enter the same value in different casing, it just makes the casing consistent).
I used this to check Prefixes of constituents. If a person doesn't have a prefix it is returning a "True" value. Is there something I can add to ignore empty records?
IsUpperCase = IF(EXACT(UPPER(data[string]), data[string]), TRUE(), FALSE())
Proud to be a Super User!
No. You can create a custom function using Text.Lower and/or Text.Upper, like:
(Text as text) as logical => let IsTextAllUpperCase = Text.Upper(Text) = Text in IsTextAllUpperCase
Thanks @MarcelBeug and @Anonymous
I didn't think of comparing a letter to it's uppercase version.
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |