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 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:

Other functions related to Text.Lower are:

BI Gorilla Youtube Channel

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/text-lower
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.