LOWER Function (DAX)

How does the LOWER function (DAX) work?

The LOWER function (DAX) converts all letters to lowercase in a text string.

LOWER Formula Syntax

LOWER(
     <text>
)

How do you use the LOWER function?

Lowercase text.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the LOWER function

Characters which are not letters will not change.

Related Video Tutorials

Ultimate Beginners Guide to DAX
What-Is-DAX-Why-Do-You-Need-To-Learn-It-1.2-Ultimate-Beginner-Guide-to-DAX

Formula examples using the LOWER function

=LOWER (
      “ABCDE”
)
returns abcde.

= LOWER (
    “123AB”
)
returns 123ab.

= LOWER (
    ‘New Products'[ProductCode]
)

Related DAX Functions

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