Text.Upper
A text in capital letters.
Group: Text and characters. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Text.Upper(text as nullable text, optional culture as nullable text) as nullable text| Parameter | Type | Description |
|---|---|---|
text | nullable text | The text to work on; null gives null. |
culture | nullable text optional | A culture's name, such as "tr-TR", for that language's own letter rules; left out, the query's culture. A name no culture has is an error. |
Returns
nullable text. The text in upper case; null when the text is null.
Remarks
- Letters of every alphabet change as in Power Query: æ ø å become Æ Ø Å, and Polish or Czech names such as Łódź or Žena get their capitals. ß has no capital here and stays ß.
- In Turkish and Azerbaijani (tr-TR, az) i becomes the dotted İ. Left out, the culture is the query's (
Culture.Current): the model's Locale for import, else the model's own culture, else en-US. The examples here run in en-US. - A useful step before comparing codes typed by hand, such as product codes.
Examples
A product code typed in small letters
Text.Upper("sku-a12")"SKU-A12"Nordic and Polish letters
Text.Upper("smørbrød i łódź")"SMØRBRØD I ŁÓDŹ"Turkish
Text.Upper("istanbul", "tr-TR")"İSTANBUL"