Convert a specific excel formula to excel

[KristofferAJ]

Hi

I have a formula I use a lot in my excel analysis, but I want to built into powerBi as a calculated column:

=iferror(MID(A1,FIND("TCN",A1),11),A1)
Can I create a DAX command which does the same?

Thanks

Kristoffer

[vapid128 · Accepted solution]

=iferror(MID([colnum name],FIND("TCN",[colnum name]),11),[colnum name])

[KristofferAJ]

Hah this was Simple! - was missing a minor thing - THANKS!