LEN DAX Function

It returns a whole number indicating the number of characters in the text string. LEN always counts each character as 1.

Note: Spaces count as characters.

DAX Syntax LEN(text)

The text specifies the text whose length we want to find, or a column that contains text.

Example 1: The following formula find the length of the text in the column Name.

DAX

= LEN([Name])

Example 2: The following measure returns the result 9, as it included the space also as one character.

DAX

Measure 2 = LEN("I got it.")
LEN dax function