LOWER
A text in lower case.
Group: Text. Compatible with DAX.
Syntax
LOWER ( <text> )| Parameter | Type | Description |
|---|---|---|
text | Text | The text to write in small letters; a number becomes text first. |
Returns
Text. The text with every capital letter made small.
Remarks
- Only letters change; digits and signs stay as they are. Æ, Ø and Å become æ, ø and å.
- A blank gives BLANK.
- Comparing texts with
=already ignores case, so LOWER is for showing text, or for preparing it forEXACTorFIND, where case counts.
Examples
Small letters
EVALUATE
ROW ( "IPA", LOWER ( "IPA" ), "ÆØÅ", LOWER ( "ÆØÅ" ), "Blank", LOWER ( BLANK () ) )| IPA | ÆØÅ | Blank |
|---|---|---|
| ipa | æøå | (blank) |
The products in small letters
EVALUATE
SELECTCOLUMNS (
Products,
"Product", Products[Product],
"Lower", LOWER ( Products[Product] )
)
ORDER BY [Product]| Product | Lower |
|---|---|
| Cider | cider |
| IPA | ipa |
| Lettøl | lettøl |
| Pils | pils |