Forum Discussion
using if function to create custom column
Hello All, I work with info input by sales people, so there is alot of room for human error. To account for that in my dashboards I am trying to create a custom columns that would compare specifi...
mcnemare , I doubt that # too
IN case you are trying in edit query mode. You need M code and this like dax.
Try like
if(
SUMX ("TM product enrollment master list",
Find(
("TM product enrollment master list"[Branch Description]),
("Navigator Account Extract"[Branch Description]),
,0
)
) > 0,
"No",
"Yes"
)