UPPER Function (DAX)

How does the UPPER function (DAX) work?

UPPER function (DAX) converts a text string to all uppercase letters.

UPPER Formula Syntax

UPPER (<text>)

How do you use the UPPER function?

It converts the string in the column to all uppercase. However, non-alphabetic characters are not included.

Related Blog Posts

Using-Filter-Fields-Visual-Interactions-To-Create-Compelling-Visualizations-In-Power-BI
Quick-Measures-–-How-To-Use-Them-In-Power-BI-Models

Related Support Forum Posts

Issues creating relationships due to duplicate values
Advanced Table Functions: UNION
How To Create Tables Combining UNION & ROW Function – Power BI & DAX

Considerations when using the UPPER function

Any changes will be made to characters other than alphabets.

Related Video Tutorials

How-To-Create-Tables-Combining-UNION-ROW-Function-Power-BI-DAX
Using-The-CROSSJOIN-Function-In-Power-BI-DAX-Concepts
Dynamically-Compare-Monthly-Information-Cumulatively-in-Power-BI-w-DAX-1

Formula examples using the UPPER function

= UPPER("12ab")

Related DAX Functions

Text Functions
LOWER
ROUNDUP

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.