Forum Discussion

o59393's avatar
o59393
Post Prodigy
4 years ago
Solved

Lookupvalue not working between 2 tables

Hi all   I am doing a lookup calcualted column, but doesn't work   Basically I have a table called 'Master Plant & Product' that has to xlooup its values on another table called 'SKU by line - Of...
Need Help
Show and Tell
  • KNP's avatar
    KNP
    4 years ago

    Try this instead...

    IF('Master Plant & Product'[Merged Plant & Product] IN DISTINCT('SKU by line - Official'[Merged Plant & Product]), 1,0)

     

    I may have typo'd your column names so double check those.

o59393's avatar
o59393
Post Prodigy
4 years ago

Hi KNP 

 

Look at the error after using related:

 

 

 

Strangely I do have a relationship.

 

Any idea?

 

Thanks.

KNP's avatar
KNP
Super User
4 years ago

Just did some testing/reading.

Looks like the RELATED (at least in this scenario) only works on the table on the 'many' side of the relationship. So in your case, the column would need to be added to the SKU table I believe.

 

There will be a better way. Going to do some more investigation.