Forum Discussion

nicolasvc's avatar
nicolasvc
Icon for Helper III rankHelper III
4 years ago

Lookupvalue only returns first match

I have two tables, in the first I have a product for the first week of the month (the week is the number in the year), and in the second table I have the value of each product but for all the weeks o...
Show and Tell
Tips and Tricks
Tutorial Requests
goncalogeraldes's avatar
goncalogeraldes
Icon for Super User rankSuper User
4 years ago

Hello there nicolasvc ! This looks like something I would either do with the RELATED() function or through a merge in Power Query. Why not try it this way?