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-5: 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: