Text.Lower Power Query Function

Text.Lower Power Query Function

Text.Lower is a power query function that converts all the letters in the provided string to lowercase. In this article, we will explore Text.Lower power query function and how to use it with the help of an example.

Let’s begin.

Syntax

Text.Lower(Given String)

It takes one parameter as a string that is compulsory and returns all the letters in that string in lowercase.

Text.Lower Power Query Example

Let’s take the following example: we have a few users’ names that we want to convert lowercase, as you can see below.

Users dataset

Now we have to apply the following function to convert all the names in the name column to small letters, as you can see below.

Text.Lower Power query function

By applying the above formula, we will get the following result, as you can see below.

Text.Lower output

In the column “Lower Case” column, you can see all the letters are now lowercase.

To learn more, please visit Learn DAX

Similar Posts