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 

 

The purpose is to have an alert system when user misses adding the correct data. Long story short I summarized it in that excel to not include all the model and sensible data.

 

Can we have it in dax calculated column? 

Thanks !!

KNP's avatar
KNP
Super User
4 years ago

If you need a DAX solution I'll leave it for someone better versed in DAX.

If you wanted Power Query I'd simply merge with appropiate joins to only keep existing/non-existing.