Events
Become a Certified Fabric Data Engineer
Jan 14, 11 PM - Mar 31, 11 PM
Check your eligibility for an exam discount offer and register for free live sessions to prepare for Exam DP-700.
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: Calculated column Calculated table Measure Visual calculation
Returns the number of characters in a text string.
LEN(<text>)
Term | Definition |
---|---|
text |
The text whose length you want to find, or a column that contains text. Spaces count as characters. |
A whole number indicating the number of characters in the text string.
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.
LEN always counts each character as 1, no matter what the default language setting is.
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.
The following formula sums the lengths of addresses in the columns, [AddressLine1] and [AddressLine2].
= LEN([AddressLine1])+LEN([AddressLin2])
Events
Become a Certified Fabric Data Engineer
Jan 14, 11 PM - Mar 31, 11 PM
Check your eligibility for an exam discount offer and register for free live sessions to prepare for Exam DP-700.
Learn more