Forum Discussion
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 Laagste Prijs" from the table Verpakking in the product table.
There is a relationship between the two tables (based on the product_id).
So I don't realy understand why I can't find the the tables using the related function.
I've added a link to the pbix file.
Can someone help me?
Kind regards,
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
4 Replies
SL_1983,I tried something like this as a new column in the product table and seems to work
Column = minx(filter(Verpakking,'Product'[Product_ID]=RELATED('Product'[Product_ID])),Verpakking[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
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:
