Len
Returns the number of characters in a specified string.
Syntax
Len(String_Expression)
Arguments
String_Expression | MDX expression that returns a string. |
|---|
Examples
Here is one example in the report to count the length of customer name: https://eazybi.com/accounts/1/cubes/Sales/reports/857349-customers-by-length-of-customer-name
Another example counts the commas in the property "Issue custom date old values". When the Jira date picker custom field "Custom date" is imported with change history which automatically generates a measure issue Custom date old values for each issue. That property stores all the previous dates for the date picker field "Custom date" and those dates are generated as a comma-separated list.
Len([Measures].[Issue Custom date old values]) - Len(Replace([Measures].[Issue Custom date old values], ',', ''))
See also
Replace function to replace a substring with another substring