Text.Upper is a Power Query M function that converts all characters in a text value to uppercase. The function returns the text value with all characters in uppercase, with an optional culture parameter to customize the conversion.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Text.Upper( text as nullable text, optional culture as nullable text, ) as nullable text
|text||The string to transform into uppercase.|
|culture||optional||The culture argument enables the specification of a Culture code (e.g., “nl-NL” or “en-US”) to align transformations with local formatting conventions. If this argument is omitted, functions default to Culture.Current, which reflects the system’s regional settings.|
Returns the result of converting all characters in
text to uppercase. An optional
culture may also be provided (for example, “en-US”).
Text.Upper easily returns the uppercase version of a sentence.
Text.Upper( "aBcD" )
Some languages treat conversion to capital letters differently than others. Take for example the following example.
// Output: "YOU AND I ARE SO LUCKY" Text.Upper( "You and i are so lucky", "en-US")
In the English language the letter “i” is capitalized to “I”. However, the Turkish alphabet treats this letter differently.
// Output: "YOU AND İ ARE SO LUCKY" Text.Upper( "You and i are so lucky", "tr-TR")
In Turkish alphabet the letter “i” turns into the uppercase “İ”. Depending on your needs, you can use the relevant culture-code for capitalizing words respecting the grammar rules of a particular culture.
Learn more about Text.Upper in the following articles:
- Text Functions in Power Query M (150+ Examples)
Your guide to Text Functions in Power Query M. Learn from practical examples and master Power Query’s most useful Text functions. » Read more
Other functions related to Text.Upper are: