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

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.

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