Problem with related function

[SL_1983]

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. 

pbix file 

Can someone help me?

Kind regards,

[Pragati11 · Accepted solution]

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

[SL_1983]

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:

https://1drv.ms/u/s!AuaqHTxLCZ_h0n02cC5-BtXWwx3b?e=ljZIHM

[Pragati11]

HI @SL_1983 ,

Can you please mark the solution which ever worked for you?

Thanks,

Pragati

[amitchandak]

@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])