Forum Discussion

Msaba's avatar
Msaba
Frequent Visitor
4 years ago
Solved

Convert Excel 'search' function to DAX PowerBi

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([@...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Msaba , a new column like

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