<!-- https://learnsql.cpetoday.com/functions/dax/lower -->
# LOWER

Language: DAX
Category: Text
Syntax: LOWER(<text>)
Summary: Converts all letters in a text value to lower case.
Returns: Text (a scalar).
Level: Beginner
Related: UPPER, TRIM, LEN, SEARCH, FIND, CONCATENATE

## 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.

```dax
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:

```dax
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.
