Extact text from multiple Delimiters

[v_mark]

I know there is a way to do this in Power Query but I am just wondering if there is an option in DAX primarily in a calculated column. 

Currently my data looks like this . Thanks in advance!

Code	Expected result
BSA06 Test North - 19C	19C
ASA01 Test-ABC - 32B	32B
ESA05 NotReal – 15	15
TSA01 Awesome Rural - Prov	Prov

[Ahmedx]

try to write like this

Text.Trim(Text.Range(
  [Code], 
  Text.PositionOfAny(
    [Code], 
    {Character.FromNumber(8211), Character.FromNumber(45)}, 
    RelativePosition.FromEnd
  )
    + 1
))

Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RhkhamWLt92LapWi6?e=vnoowN

[Ashish_Mathur]

Hi,

Try this calculated column formula

Column = mid(Data[Code],SEARCH(" - ",Data[Code],,0)+3,50)

It does not work for the third one, because that symbol is not a -.

[ribisht17]

@v_mark 

Please check this post and solution https://community.powerbi.com/t5/Desktop/Splitting-Text-on-multiple-delimiters-with-DAX/m-p/2480035

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series