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 text
Argument | Attribute | Description |
---|---|---|
text | The text value to transform into lowercase. | |
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. |
Description
The Text.Lower function returns the result of converting all characters in text
to lowercase. An optional culture
may also be provided (for example, “en-US”).
Examples
Basic Example: Converting to Lowercase
To convert the sentence “LETS GET iT STARted” to lowercase, use the following code:
Text.Lower( "LETS GET iT STARted" ) // output: "lets get it started"
Handling Different Languages
Some languages handle lowercase conversion differently. To provide specific instruction for a particular culture, you can use the optional culture parameter. For example, in English:
// 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. You can specify that using the “tr-TR” culture parameter as follows:
// 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:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy