Measure to extract specific digits from a text

[Anonymous]

Hi,

What measure can I use to extract from the 18th digit of a given text to the 21 (4 Digits)

Data

This is easy in excel, using probably  =len and or =mid formulas

Please advice

-Z

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your description, you want to get a measure that can get the 4 digits text from 18^th to 21th, you can try my steps:

1. Create a measure:

Digit 18 through 21(4 digits) =

var _text=MID(MAX([Serial_Number]),18,4)

return

IF(ISBLANK(_text),"Don't have a value",_text)

2. Create a table chart and place column and measure like this:

And you can get what you want.

You can download my test pbix file here

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

Write this calculated column formula

=mid(data[serial_number],18,4)

Hope this helps.

[Anonymous]

Sorry Ashish, I'm look for a measure because the data set I'm using does not allow me to create columns, but thank you, is there something else similar using "measures" ?

Best regards,

[Ashish_Mathur]

You are welcome.  Try this measure

=if(hasonevalue(Data[text]),mid(max(data[serial_number]),18,4),blank())