LOWER DAX Function (Text)
Converts all letters in a text string to lowercase.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Text |
The text you want to convert to lowercase. Characters that are not letters are not changed. |
Return values
Text in lowercase.
» 1 related function
Examples
-- UPPER and LOWER convert their only argument in uppercase or lowercase, respectively
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 articles
Learn more about LOWER in the following articles:
-
Letter case-sensitivity in DAX, Power BI and Analysis Services
Power BI and Analysis Services are case-insensitive by default.Lowercase letters are identical to uppercase letters.This is mostly a good choice, but it also comes with unexpected consequences. In this article, we run through a set of queries to understand what to be aware of when working with a mixture of lowercase and uppercase strings in DAX. » Read more
Related functions
Other related functions are:
Last update: Apr 11, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://docs.microsoft.com/en-us/dax/lower-function-dax