DAX Function Guide

LOWER
Empty image or helper icon

Sam McKay

CEO & Founder

How does the LOWER 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?

Lowercase text.

Related Blog Posts

Loading

Considerations when using the LOWER?

Characters which are not letters will not change.

Related Video Tutorials

Loading

Formula examples using the LOWER

=LOWER (
      “ABCDE”
)
returns abcde.

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

= LOWER (
    ‘New Products'[ProductCode]
)

Related Courses

Loading