Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I am already joined to the Power bi world and we have started to get data form SAP BW to combiner order and stock report.
Current data:
Component from Bom | Finished good | Stock Identifier | Warehouse code | Stock qty | Order Qty | Total order of the Fisnished good | Date of Order |
151109-TA | 151109-AI | 1085 | 22 | ||||
151109-TA | 151109-AI | 1328 | 23 | ||||
151109-TA | 151109-AI | O | 634 | ||||
151109-TA | K51109-AI | # | 1085 | 22 | 225 | 6870 | 14.07.2023 00:00 |
151109-TA | K51109-AI | O | 2000 | 634 | 300 | 6870 | 19.02.2025 00:00 |
151109-TA | K51109-AI | O | 2000 | 634 | 45 | 6870 | 22.03.2025 00:00 |
151109-TA | Y51109-AI | 1085 | 22 | 300 | 3394 | 27.10.2023 00:00 | |
151109-TA | Y51109-AI | 1085 | 22 | 300 | 3394 | 21.11.2023 00:00 | |
151109-TA | Y51109-AI | 1085 | 22 | 300 | 3394 | 22.01.2024 00:00 | |
151109-TA | Y51109-AI | 1085 | 22 | 300 | 3394 | 20.02.2024 00:00 | |
151109-TA | Y51109-AI | 1085 | 22 | 300 | 3394 | 22.03.2024 00:00 | |
151109-TA | Y51109-AI | 2000/1085 | 22 | 300 | 3394 | 22.05.2024 00:00 | |
151109-TA | Y51109-AI | 2000/1085 | 22 | 300 | 3394 | 22.08.2024 00:00 | |
151109-TA | Y51109-AI | 2000/1085 | 22 | 300 | 3394 | 21.09.2024 00:00 | |
151109-TA | Y51109-AI | 1040 | 22 | 300 | 3394 | 21.11.2024 00:00 | |
151109-TA | Y51109-AI | 1085 | 22 | 300 | 3394 | 22.12.2024 00:00 | |
151109-TA | Y51109-AI | 1085 | 22 | 300 | 3394 | 19.02.2025 00:00 | |
151109-TA | Y51109-AI | 1085 | 22 | 94 | 3394 | 22.03.2025 00:00 | |
151109-TA | Y51109-AI | 2000/1328 | 23 | 300 | 3394 | 27.10.2023 00:00 | |
151109-TA | Y51109-AI | 2000/1328 | 23 | 300 | 3394 | 21.11.2023 00:00 | |
151109-TA | Y51109-AI | 2000/1328 | 23 | 300 | 3394 | 22.01.2024 00:00 | |
151109-TA | Y51109-AI | 2000/1328 | 23 | 300 | 3394 | 20.02.2024 00:00 | |
151109-TA | Y51109-AI | 2000/1328 | 23 | 300 | 3394 | 22.03.2024 00:00 | |
151109-TA | Y51109-AI | 2000/1328 | 23 | 300 | 3394 | 22.05.2024 00:00 | |
151109-TA | Y51109-AI | 2000/1328 | 23 | 300 | 3394 | 22.08.2024 00:00 |
We sould like to convert to like below depends on the finished goods of the smilar components. So I mean 151109-TA is parts of the
K51109-AI and Y51109-AI finsihed goods. So we need to split each stock based on their order qty weight.
So we would like convert like below, can you help me?
Thx
Component from Bom | Component | Stock Identifier | Warehouse code | weight of order-rate of the order | 1085-warehouse quantitiy | 1328-warehouse quantitiy | 1040-warehouse quantitiy | July | August | September | October | |
K51109-AI | 151109-TA | O | 1085 | =3394/6870+3394 | current stock qty in 1085 warehouse * rate of the order | current stock in warehouse * rate of the order | current stock in warehouse * rate of the order | 300 | 1200 | 6000 | 7000 | |
Y51109-AI | 151109-TA | O | 1328 | =6870/6870+3394 | current stock qty in 1328 warehouse * rate of the order | current stock in warehouse * rate of the order | current stock in warehouse * rate of the order | 300 | 6000 | 7000 |
Hi @OzgurKlc ,
Sorry I'm not quite clear about the transform logic "convert depends on the finished goods of the smilar components." and "split each stock based on their order qty weight.". Could you please clarify it based on the sample data.
Best regards,
Community Support Team_yanjiang
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
171 | |
109 | |
109 | |
73 | |
71 |