Inventory profile with running sum

[DBNN]

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

[rfigtree]

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.