DAX function
UPPER / LOWER — DAX function reference
Change case.
Syntax
dax
UPPER(<text>) LOWER(<text>)
Examples
dax
UPPER([Code])
→ Text
dax
LOWER(TRIM(Customer[Email])) = LOWER(TRIM(Customer[ConfirmEmail]))
→ Case- and whitespace-insensitive email match, in a calculated column
dax
UPPER(LEFT(Product[Category], 1)) & LOWER(MID(Product[Category], 2, LEN(Product[Category])))
→ Title-cases a category value so "BIKES" and "bikes" both become "Bikes"
Common mistakes & gotchas
- DAX text comparisons (=, <>) are already case-insensitive by default in most contexts, so UPPER/LOWER purely for comparison is often unnecessary — reach for it when you need the actual case-normalized text for display or concatenation, not just to compare two values.
Related DAX functions
From Text