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?
Go to Solution.
No. You can create a custom function using Text.Lower and/or Text.Upper, like:
(Text as text) as logical =>
IsTextAllUpperCase = Text.Upper(Text) = Text
View solution in original post
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).
Thanks @MarcelBeug and @Anonymous
I didn't think of comparing a letter to it's uppercase version.
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!