LOWER DAX Function (Text)

Syntax  |  Return values  |  Examples  |  Related  

Converts all letters in a text string to lowercase.

Syntax

LOWER ( <Text> )

Parameter	Attributes	Description
Text		The text you want to convert to lowercase. Characters that are not letters are not changed.

Return values

Scalar A single string value.

Text in lowercase.

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

• UPPER

Last update: Jul 24, 2021   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

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