Convert Excel 'search' function to DAX PowerBi

[Msaba]

Need assistance in converting this excel function to Dax  Power Bi. 

=IF(ISNUMBER(SEARCH("REL CNF",[@[System status]])),"CNF",MID([@[System status]], 1, 4))

output:

True="CNF"

False="MID([@[System status]], 1, 4)"

Thank you a lot!

[Msaba]

@amitchandak It perfectly working, thank you so much!

[AllisonKennedy]

@Msaba  You can use DAX text functions, they are all very similar to the Excel functions: 

https://dax.guide/functions/text/ 

[amitchandak · Accepted solution]

@Msaba , a new column like

if(SEARCH("REL CNF",Table[System status],,0)>0,"CNF",MID(Table[System status], 1, 4))