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 s...
Tips
  • vapid128's avatar
    vapid128
    4 years ago

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

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!