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
Text.Lower( text as nullable text, optional culture as nullable text, ) as nullable text
Returns the result of converting all characters in
text to lowercase. An optional
culture may also be provided (for example, “en-US”).
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.
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
Other functions related to Text.Lower are: