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


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 (

= LEN (

Related Course Modules



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.