Forum Discussion

MagMag31's avatar
MagMag31
Regular Visitor
3 years ago
Solved

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 cal...
DAX
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi MagMag31 
    Please try

    Result =
PATHITEM ( SUBSTITUTE ( SELECTEDVALUE ( 'Table'[Text] ), " - ", "|" ), 2 )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi MagMag31 
Please try

Result =
PATHITEM ( SUBSTITUTE ( SELECTEDVALUE ( 'Table'[Text] ), " - ", "|" ), 2 )
MagMag31's avatar
MagMag31
Regular Visitor
3 years ago

It works, thank you so much !!👍