Home » DAX » DAX – LOWER Function

DAX – LOWER Function

LOWER DAX Functions

Power Bi DAX LOWER function is used to converts the given string into lowercase. Its comes under Text function Dax category.

Syntax:

LOWER(string)

Description:

S no. Parameter Description
1 String The text you want convert into lowercase.

Let’s start with an example:

Step 1: Sample Dataset as below:

Sample Dataset for DAX String Functions

Sample Dataset for DAX String Functions

Step 2: Create New column, right click on Dataset & click on New column.

Create New Column

Create New Column

Step 3: After that DAX formula screen appears.

Step 4: write DAX formula there to convert Product sub category column strings to lowercase & press enter.

LowerCase = LOWER(Orders[Product Sub-Category])

Step 4: Now Drag new column to Table visual & output as below.

Lower function Output

Lower function Output

 

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.

Recommended Power Bi Post:

UPPER

ALLEXCEPT

UNION

DATATABLE

ALLSELECTED

ALL

ADDCOLUMNS

 

Leave a Reply