Summarize products and supplies

[JorgeConil]

Dears,

I would appreciate opinions or suggestions on how I should approach the following situation:

I have a table with the composition (structure) of Products, that is, the Item ART01001 is made up of: 10pcs of INS01001, 20pcs of INS01002 and 5pcs of INS01003, etc.

In turn, an Cod_Father can be a Cod_Child of another product.

Cod_Father	Cod_Children	Quantity
ART01001	INS01001	10
ART01001	INS01002	20
ART01001	INS01003	5
ART01002	INS01001	5
ART01002	INS01003	3
ART01002	INS01004	10
ART01002	INS01005	5
ART01003	ART01001	1
ART01003	INS01003	3
ART01003	INS01004	2

Also I have another table that contains the quantity in stock of all goods in different warehouses.

SKU	WarehouseID	Stock
ART01001	W1	12
ART01001	W2	2
ART01002	W2	5
ART01003	W1	1
ART01003	W2	5
ART01003	W3	1
INS01001	W1	100
INS01001	W2	50
INS01001	W3	20
INS01002	W1	20
INS01002	W2	40
INS01002	W3	5
INS01003	W1	0
INS01003	W2	100
INS01003	W3	100
INS01004	W1	50
INS01004	W3	30
INS01005	W1	35
INS01005	W3	20

I would like to obtain the list of each product composition with the stocks of each part, as follows:

What can you suggest to me?

Regards,

Jorge

[v-cgao-msft · Accepted solution]

Hi @JorgeConil ,

How did the last two lines of the expected output get there?
Check that this matches your expected output:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly--How to provide sample data in the Power BI Forum--China Power BI User Group

[JorgeConil]

Hi,

Thank you so much! Your example is very close to what I need.