LOWER

Updated on

LOWER is a DAX function that converts all letters in a text string to lowercase.

Syntax

LOWER( Text )
Argument Properties Description
Text The text you want to convert to lowercase. Characters that are not letters are not changed.

Return Values

Text in lowercase.

Remarks

Characters that are not letters are not changed. For example, the formula = LOWER("123ABC") returns 123abc.

Example

The following formula gets each row in the column, [ProductCode], and converts the value to all lowercase. Numbers in the column are not affected.

= LOWER('New Products'[ProductCode])

Other functions related to LOWER are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/lower-function-dax

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy