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

I was able to resolve this it was '#', using ' is better.

 

I am now getting an error stating that

 

Too many arguments were passed to the FIND function. The maximum argument count for the function is 4.

 

I'm only comparing the same 2 variables from two seperate tables.

 

Any thoughts ? @Greg_Deckler

 

if(
    Find(
        ('TM product enrollment master list'[Branch Description]),
        ('Navigator Account Extract'[Branch Description]),,
        ,0
    ) > 0,
    "No",
    "Yes"
)

---

 

Below is a simplified example of the data I am working with.

 

I am wanting to make the calulated column on the sales module table. 

 

 

 

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

mcnemare Sorry, I missed that you had a comma in the next row, should be:

if(
    Find(
        ('TM product enrollment master list'[Branch Description]),
        ('Navigator Account Extract'[Branch Description]),
        ,0
    ) > 0,
    "No",
    "Yes"
)
  • 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.