Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
Hi,
Thank you so much! Your example is very close to what I need.
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |