Forum Discussion
IF and LOOKUP for multiple values
Hi, I have two tables, spend table and contract table similar to the below normalised data I have linked the two tables by Vendor ID and have a dim-date (calendar) table. This may be two issues...
Anonymous , I am assuming you are trying for a new column
Contract = if(MAxx(filter('Contract-Data','Contract-Data'[Vendor Id] =[Vendor]), 'Contract-Data'[Term Type]) = "Published","Yes","No")
if needed
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Hi, thanks, that has got rid of the error, but all the responses are "no" when there definately should be some "yes"
Anonymous , Can you share sample data and sample output in table format?
I can't work out how to attach an excel spreadsheet to share the data
Anonymous please upload in 1/g drive and share the link here and mention the desired end result too.
