Text.Lower

Updated on

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
ArgumentAttributeDescription
textThe text value to transform into lowercase.
cultureoptionalThe 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.

Learn more about Text.Lower in the following articles:

Other functions related to Text.Lower are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/text-lower

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy