UPPER DAX Function (Text)

Syntax  |  Return values  |  Examples  |  Related  

Converts a text string to all uppercase letters.

Syntax

UPPER ( <Text> )

Parameter	Attributes	Description
Text		The text you want converted to uppercase, or a reference to a cell that contains a text string.

Return values

Scalar A single string value.

Text in uppercase.

» 1 related function

Examples

--  UPPER and LOWER convert their only argumenti in lowercase or uppercase
DEFINE 
    VAR Val = "DAX is so cool!"
EVALUATE
{
    ( "Original = " &      Val          ),
    ( "UPPER = " & UPPER ( Val        ) ),
    ( "LOWER = " & LOWER ( Val        ) )
}

Value
Original = DAX is so cool!
UPPER = DAX IS SO COOL!
LOWER = dax is so cool!

Related functions

Other related functions are:

• LOWER

Last update: May 12, 2021   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

Microsoft documentation: https://docs.microsoft.com/en-us/dax/upper-function-dax