Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

IF statement question - Many to Many relationship

I'm trying to make a new column that tells me if a customer is new or old based on if their assigned ID exists in the table for old clients (Old) or not. But I get an error when making this column us...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Check the formula.

    Column = IF(new[customer] in VALUES(old[customer]),"old","new")

     

     

    Best Regards,

    Jay

parry2k's avatar
parry2k
Super User
5 years ago

Anonymous Unfortunately you can add a column like that when using many to many, you should think of adding as a measure.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for the reply, 

 

Not quite sure how to write that measure, I can't seem to use the columns that I want. Seems I can only use measures with IF statements? 

 

I also tried using "LOOKUPVALUE" but I can't use Customer No as both search_columnName and search_value. I can't use a fixed search_value because I obviously want it to be dynamic and find all the records that exist in both tables, not just a specific customer. 

 

Just to try, I tried using a specific customer no, but I get an error saying: 

 

The column 'BefintligaKunder[Customer No]' either doesn't exist or doesn't have a relationship to any table available in the current context.

 

(BefintligaKunder is the table for old customers)