Downloads
DAXTextBeginner

LOWER

Converts all letters in a text value to lower case.

Syntax
LOWER(<text>)

Returns: Text (a scalar).

What it does

LOWER changes every letter in a text value to lower case. It is the mirror of UPPER and is used for the same purpose: making text comparable. Email addresses are a common case, because the same address can be typed with capitals in one system and not in another.

Syntax and arguments

Example

The marketing team wants to remove duplicate customers who appear twice in the list because their email addresses differ only in case.

Email Key = LOWER(TRIM(Customer[Email]))

Two records with "Jane.Doe@Example.com" and "jane.doe@example.com " get the same key. A count of distinct keys then shows the true number of customers.

Example: a second, different use

Make a product description consistent for a search box, which is case blind for the user:

Search Text = LOWER(Product[ProductName])

Searching on the lower case version means the user does not need to type the right capitals.

Things to watch

In business terms

LOWER supports clean customer and vendor masters, duplicate detection and matching of emails to records before a campaign or a payment. Finance teams use it when a dedupe check must confirm that one payee is not paid twice under two spellings.

Related functions

All DAX functions · View as Markdown · DAX fundamentals