Power BI UPPER DAX function converts the given string into uppercase letters. Its comes under Text functions DAX category.
|1||String||The text you want convert into uppercase.|
Let’s start with an example:
Suppose you have one users dataset with two columns as mentioned below
Now you want to change Region column data into uppercase letter, for this you have to follow below steps:
Step 1: Create new column, Right click on your dataset name, then select New column
Step 2: After that one DAX formula screen appears, write below DAX function there.
Region_New = UPPER(Users[Region])
- Region_Name : New column name
- UPPER : DAX Function name
- Users : Dataset name
- [Region]: Column name, which data you want to convert in uppercase
Step 3: Drag new column to Table visual and output as below with upper letters.
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: