Downloads
DAXTextBeginner

UPPER

Converts all letters in a text value to capitals.

Syntax
UPPER(<text>)

Returns: Text (a scalar).

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

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.

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:

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

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.

Related functions

All DAX functions · View as Markdown · DAX fundamentals