Forum Discussion

mcnemare's avatar
mcnemare
Frequent Visitor
5 years ago

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...
Need Help
mcnemare's avatar
mcnemare
Frequent Visitor
5 years ago

@Greg_Deckler ,

It's fine. I apprecicate all the help.

I recieved this error, I am thinking that due to the amount of variables I have are too many. Would your reccomend another DAX function or method in this case?

Error returend is:


A single value for column 'Branch Description' in table 'TM product enrollment master list' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

Column = if(
    Find(
        ('TM product enrollment master list'[Branch Description]),
        ('Navigator Account Extract'[Branch Description]),
        ,0
    ) > 0,
    "No",
    "Yes"
)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

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?

  • mcnemare's avatar
    mcnemare
    Frequent Visitor
    5 years ago

    yes Greg_Deckler ,

     

    I am trying to create a calcualted column to ID data mimatches and to filter them out of dashboard visuals.