LEN Function (DAX)

How does the LEN function (DAX) work?

The LEN function (DAX) returns the number of characters within a text string.

LEN Formula Syntax

LEN(
     <number>
)

How do you use the LEN function?

DAX uses Unicode, and stores the same length of all characters. Therefore LEN always counts each character as 1 regardless of the default language setting.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the LEN function

If you are using the DAX LEN function with a column containing non-text values such as dates or boolean values, the function will implicitly translate the value into text using the current column format.

Related Video Tutorials

Ultimate Beginners Guide to DAX

Formula examples using the LEN function

=LEN (
      [AddressLine1]+[AddressLine2]
)

= LEN (
    [Product]
)

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD


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


Download DAX Formula Reference Guide