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 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 substring with another substring