LOWER
Converts all letters in a text value to lower case.
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
- text: the value to convert.
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
- LOWER is for keys and comparisons. Show the normal form to the reader.
- Email addresses are generally case insensitive in practice, but some systems treat them as case sensitive. Know the rule before you merge records.
- LOWER does not remove spaces. Combine it with TRIM.
- LOWER returns text.
- For a text match inside a filter, DAX compares text without regard to case, so LOWER is for keys, not for filters.
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.