Need help on DAX to extract a character between delimeter

[juhoneyighot]

Hello. PBIX file is in Direct Query. Please see table below. I have a Phase Column. What I want is the Phase2 Column. We will get Phase2 column for this condition:

If Phase= blank then blank 

else

extract Phase2 characters after the last _ in Phase Column.

stx_jobtype_txt	NC.IN	Phase	Phase2
NC 110_Estimates__90Complete	NC	NC 110_Estimates	Estimates
IN 610_CO EQ_Estimate__90Complete	IN	IN 610_CO EQ_Estimate	Estimate
NC.IN 720_Dehu_Estimate__40Contract Executed	NC.IN	NC.IN 720_Dehu_Estimate	Estimate
012 Service_Service Call
NC 120_Rough Builder Walk__90Complete	NC	NC 120_Rough Builder Walk	Rough Builder Walk
IN 642_CO Duct_Builder_Walk__90Complete	IN	IN 642_CO Duct_Builder_Walk	Walk

Thank you.

[Ahmedx]

pls try this

[juhoneyighot · Accepted solution]

@Ahmedx 

it works with this formula without the var

Phase3 =
IF(NOT ISBLANK ('stx__legacy_fsjob'[Phase]),PATHITEMREVERSE(SUBSTITUTE('stx__legacy_fsjob'[Phase],"_","|"),1))

[juhoneyighot]

@Ahmedx 

If Phase column is a measure would it affect the formula. I entered the formula above but this error occurs.