<!-- https://learnsql.cpetoday.com/functions/dax/upper -->
# UPPER

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

## What it does
UPPER changes every letter in a text value to a capital. Numbers and punctuation are not changed. It is most useful for matching: two spellings of a vendor name that differ only by case become the same text after UPPER. Use it on keys and codes before you compare them, or before you build a list that must match another system.

## Syntax and arguments
- text: the value to convert, a column or a text value.

## Example
A bank feed and the vendor master both contain vendor names, but the bank writes them in capitals and the master uses normal case. The reconciliation needs a common key.

```dax
Vendor Match Key = UPPER(TRIM(Vendors[VendorName]))
```

TRIM removes stray spaces first, then UPPER makes the text capitals. Matching on this key lines up "Acme Supply" with "ACME SUPPLY" and with "acme supply ".

## Example: a second, different use
Standardize product codes in a catalog that was entered by hand in mixed case:

```dax
Product Code Clean = UPPER(Product[ProductCode])
```

Codes such as "ab-120" and "AB-120" become one code. Use the cleaned column for grouping or for a relationship to a second table.

## Things to watch
- UPPER does not change the meaning of a value, but it can break a match to a source that is case sensitive. Check the rule in the other system.
- Comparisons in DAX on text are not case sensitive for most purposes, so UPPER is not always needed for a filter. It is needed for a key, a concatenation or a display.
- Do not use UPPER to display a name in a report. Use the normal form for readers.
- UPPER returns text. It does not change a number.

## In business terms
UPPER is part of the data cleaning that makes vendor, customer and account matching work. A reconciliation that fails because of capitals costs time, and a standard key removes that cost before the close.
