Wildcards with IF in DAX
Hello All, I have a table like this in Excel where column "B" is bringing "TRA" everytime it finds that word within the codes in column "A"... no matter where "TRA" is positioned in the word. For doing so, i'm using ISNUMBER + SEARCH formulas and works like a charm. Can you guys please help me replicate this in DAX?? This is the formula in cell B2: =IF(ISNUMBER(SEARCH($B$1;A2));"TRA";"") Thanks! Edson
