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.