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
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership