Forum Discussion
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...
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.
As far as the report is concerned, what is the purpose of the 'Product Exists' column?
Would you be happy for a Power Query solution or does it need to be DAX?