How to extract first 5 characters from a measure value in EazyBI

How to extract first 5 characters from a measure value in EazyBI?

Example: Incase my measure value is “ABC-12DEFGHI23JK98L-MNOPQRS-T56UVWXYZ0” then I would want to extract only ABC-12

Please let me know how we can achieve this.

You can use Left(string, 5) to archieve that. If you need more complex extraction from the string then use ExtractString with a regular expression.

You can take a look also on other useful MDX functions.