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 It look like you are trying to create a measure for this. What was provided was a formula for a new column. (Hence the "Column =" at the start of the formula. If you want a measure, you need to wrap an aggregator around your column references like:
Measure = IF(
FIND(
MAX('TM product enrollment master list'[Branch Description]),
MAX('Navigator Account Extract'[Branch Description]),
,0
) > 0,
"No",
"Yes"
)But I am pretty sure you want a column, right?
yes Greg_Deckler ,
I am trying to create a calcualted column to ID data mimatches and to filter them out of dashboard visuals.