Forum Discussion

KristofferAJ's avatar
KristofferAJ
Icon for Helper III rankHelper III
4 years ago
Solved

Convert a specific excel formula to excel

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

Tips
  • vapid128's avatar
    vapid128
    4 years ago

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

2 Replies

  • vapid128's avatar
    vapid128
    Icon for Solution Specialist rankSolution Specialist
    4 years ago

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

    • KristofferAJ's avatar
      KristofferAJ
      Icon for Helper III rankHelper III
      4 years ago

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