Power Bi DAX LOWER function is used to converts the given string into lowercase. Its comes under Text function Dax category.
|1||String||The text you want convert into lowercase.|
Let’s start with an example:
Step 1: Sample Dataset as below:
Step 2: Create New column, right click on Dataset & click on 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.
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: