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