Forum Discussion
MagMag31
3 years agoRegular Visitor
Extract String after certain symbol with a measure
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
Hi MagMag31
Please tryResult = PATHITEM ( SUBSTITUTE ( SELECTEDVALUE ( 'Table'[Text] ), " - ", "|" ), 2 )