LEN

Applies to: Calculated column Calculated table Measure Visual calculation

Returns the number of characters in a text string.

Syntax

LEN(<text>)

Parameters

Term Definition
text The text whose length you want to find, or a column that contains text. Spaces count as characters.

Return value

A whole number indicating the number of characters in the text string.

Remarks

  • Whereas Microsoft Excel has different functions for working with single-byte and double-byte character languages, DAX uses Unicode and stores all characters with the same length.

  • If you use LEN with a column that contains non-text values, such as dates or Booleans, the function implicitly casts the value to text, using the current column format.

  • This function returns different results depending on the UnicodeCharacterBehavior setting of your model.

Example

The following formula sums the lengths of addresses in the columns, [AddressLine1] and [AddressLine2].

= LEN([AddressLine1])+LEN([AddressLin2])
  • Last updated on