search value and return X character after

[Cednok]

Hi the  community 

I have one cell like this 

i want create new column on my power bi with the reference after MDS = , this reference always contains 6 characters wich dax formule, which dax formula I could use to get this result. Thank you in advance for your help

[v-easonf-msft · Accepted solution]

Hi. @Cednok 

In PowerQuery, you can try the feature "Extract".

Add columns->exact->Text Between Delimiters

In Dax, you can try calculated column as below:

Result = 
VAR location =
    SEARCH ( "=", 'Table'[Text],, 0 )
RETURN
    MID ( 'Table'[Text], location + 1, 6 )

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Cednok , Split in Power Query by "MDS = " into 2 column  -https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

After in second column use the formula Text.Start([col2], 6)