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
Step-2: Create New column, right click on Dataset & click on 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-5: Now Drag new column to Table visual & output as below.
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: