Forum Discussion
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([@[System status]], 1, 4)"
Thank you a lot!
Msaba , a new column like
if(SEARCH("REL CNF",Table[System status],,0)>0,"CNF",MID(Table[System status], 1, 4))
3 Replies
Msaba , a new column like
if(SEARCH("REL CNF",Table[System status],,0)>0,"CNF",MID(Table[System status], 1, 4))
Msaba You can use DAX text functions, they are all very similar to the Excel functions:
amitchandak It perfectly working, thank you so much!
