topic Re: Extract String after certain symbol with a measure in DAX Commands and Tips

Extract String after certain symbol with a measure

MagMag31 — Fri, 05 May 2023 09:00:00 GMT

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

Re: Extract String after certain symbol with a measure

tamerj1 — Fri, 05 May 2023 09:25:19 GMT

Hi MagMag31
Please try

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

Re: Extract String after certain symbol with a measure

MagMag31 — Fri, 05 May 2023 12:01:07 GMT

It works, thank you so much !!👍