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: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://docs.microsoft.com/en-us/dax/lower-function-dax