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

Thank you for your assistance,

When using this function to create a custom column, it did resolve the previous issue. But I am getting

a token literal expected error.

thoughts?


(#"Navigator Account Extract"[Branch Description]),,

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

    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"
)