Home » DAX » DAX – UPPER Function

DAX – UPPER Function

UPPER DAX Functions

Power BI UPPER  DAX function converts the given string into uppercase letters. Its comes under Text functions DAX category.

Syntax:

UPPER(string)




Description:

S no. Parameter Description
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

Sample Data




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

Create New Column

Create New Column

Step 2:  After that one DAX formula screen appears, write below DAX function there.

Region_New = UPPER(Users[Region])




DAX Description:

  • 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.

Upper Dax Output

Upper DAX 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:

ALLEXCEPT

UNION

DATATABLE

ALLSELECTED

ALL

ADDCOLUMNS

Leave a Reply