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

Questions & Answers
1

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.

2

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.

3

Hi @raimonds.simanovskis Is possible extract the first sentences ?
Ex: ABC 12 → ABC
ABCDAASD 23 → ABCDAASD