Extract String after certain symbol with a measure

[MagMag31]

Hello,

I need help please, how do you extract the text from the string after the "-" and the second space (column Text), into a new column (column Result), only with a measure. without using a calculated column or in M-Script because I connect to a dataset where I can only create measures

i think we can do it with selectedvalue but I didn't manage to do it

text	Result
001 - Hello	Hello
15 - Hi	Hi
22 - Thank you	Thank you

thank you

[tamerj1 · Accepted solution]

Hi @MagMag31 
Please try

Result =
PATHITEM ( SUBSTITUTE ( SELECTEDVALUE ( 'Table'[Text] ), " - ", "|" ), 2 )

[MagMag31]

It works, thank you so much !!👍