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

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.