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,
I have 3 simple tables:
1. Inventory
Product Inventory Plant
A | 1000 | 3000 |
A | 250 | 3001 |
B | 650 | 3000 |
B | 400 | 3001 |
2. Orders
Date Product Order ref Customer OrderQty Plant
8-Mar | A | x123 | a55 | 100 | 3000 |
9-Mar | A | x321 | b96 | 50 | 3000 |
12-Mar | A | x652 | a55 | 800 | 3000 |
20-Mar | B | x145 | a88 | 300 | 3001 |
3. Replenishment
Date Product Replen Ref ReplenQty Plant
13-Mar | A | y554 | 1000 | 3000 |
21-Mar | B | y457 | 250 | 3001 |
I try to make 1 visual that shows me the running total of inventory for plant 3000/product A, subtracting the order quantity by date and adding the replenishment by date. I tried it with the matrix visual and running totals but I failed miserably 🙂 Hope you can help
the easiest thing to do is use power query to combine all three tables together then it becomes simple to generate a running total etc.
at the very least combine the orders and replenishment tables, but you will need a composite key (plant/product) as powerbi only joins using one key column at a time.
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 |
---|---|
71 | |
37 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
32 | |
27 | |
24 | |
23 |