Forum Discussion
Solved
Problem with related function
Good morning, I have a problem with the function related. I want to create two columns using the function related in the Product table. I want to have the colums "Laagste Prijs" and "Verpakking Id...
Hi SL_1983 ,
You can create a column in "Product" Table as follows:
Laagste Prijs = LOOKUPVALUE(Verpakking[Laagste Prijs], Verpakking[Product Id], 'Product'[Product_ID])Similarly you can do for the other required column.If this helps appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi SL_1983 ,
You can create a column in "Product" Table as follows:
Laagste Prijs = LOOKUPVALUE(Verpakking[Laagste Prijs], Verpakking[Product Id], 'Product'[Product_ID])
Similarly you can do for the other required column.
If this helps appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hello,
that indeed does the trick.
Now I want to calculate the cost of the recipe using the lowest price value. I also want to calculate the price based on the package (because even though I don't need the whole package to make the recipe, i still need to buy it).
I've tried it using summarize, but that doesn't work.
The link to the file:
