Return prices even with a pool of references

[Seabastein]

Hello there, 

My BI is made of three tables:

1. One that containes the references of all the product we sale.
2. One that contains multiple references found on the market for our products in the table one the reference from the table one is in the first column and the other on other columns on the same line.
3. And a third that contains all the products and prices of a supplier

I am trying to return the prices of the supplier for our product, but dont know wich market references is the one used by the supplier.

Does someone know how I should do it ?

Thanks in advance 😀

[v-henryk-mstf]

Hi @Seabastein ,

Based on your description, no further testing can be done for you at this time. Refer to the link below for the appropriate testing information. 

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Before You Post, Read This - Microsoft Power BI Community

I will answer your questions as soon as possible. Looking forward to your reply.

Best Regards,
Henry