Text.Lower Function in Power Query

The Text.Lower function returns the lowercase of a text value.

Syntax

Text.Lower(text as nullable text, optional culture as nullable text) as nullable text

Example: Get the lowercase version of text.

Power Query M

= Text.Lower("Hello my deaR ashish Goel")

The output of the above formula is shown below:

Text.Lower function in Power Query