Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Is there a text function for checking all case in Power Query M

Hi all,   I am wondering if there is  function in the M Power Query to check all the letter in a text consist of all upper case or lower case.    For example:   "Trailer; Mario Box Tandam 2000...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous in edit query, add new custom column with following expression to get true/false

     

    [Column1]<>Text.Upper([Column1])
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous in edit query, add new custom column with following expression to get true/false

 

[Column1]<>Text.Upper([Column1])