Text.Lower is a Power Query M function that converts all characters in a text value to lowercase. The function returns the text value with all characters in lowercase, with an optional culture parameter to customize the conversion.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Text.Lower(
text as nullable text,
optional culture as nullable text,
) as nullable textDescription
Returns the result of converting all characters in text to lowercase. An optional culture may also be provided (for example, “en-US”).
Examples
Text.Lower easily returns the lowercase version of a sentence.
Text.Lower( "LETS GET iT STARted" ) // output: "lets get it started"Some languages treat conversion to lower letters differently than others. Take for example the following example.
// Output: "you and i are so lucky"
Text.Lower( "You and I are so lucky", "en-US")In the English language the word “I” is capitalized to “i”. However, the Turkish alphabet treats this letter differently.
// Output: "you and ı are so lucky"
Text.Lower( "You and I are so lucky", "tr-TR")In the Turkish alphabet the letter “I” turns into the lowercase “ı”. Depending on your needs, you can use the relevant culture code for capitalizing words respecting the grammar rules of a particular culture.
Related articles
Learn more about Text.Lower 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
Related functions
Other functions related to Text.Lower are:
