Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |