Trying to build a Line of Balance/Stock Balance chart

[AppleUSN]

I have a need to show the balance of quantity over a period of time based on supply and demand.  I am having trouble duplicating this and I cannot find a solution based on my question either so I am hoping the community can help me.  I want to calculate the running total of my stock level based on the demand date and the actual received date to show when I will be positive or negative on stock level.  I am trying to figure out how to calculate the position row below.  I can get the demand and commit qty no problem.  I can also show the difference between the two but I cannot figure out the difference with the running total.

4118215-01	Past Due	29-May	5-Jun	12-Jun	19-Jun	26-Jun	3-Jul	10-Jul	17-Jul	24-Jul
Demand Qty	19	1	5	4	2	2	0	0	0	0
Supplier Commit Qty		1	5	7	1	0	0	0	0	0
Position		(19)	(19)	(16)	(17)	(19)	(19)	(19)	(19)	(19)

Feed Data

Part Number	Qty Open	Contract Date	Dock Date
4118215-01	1	4/18/2023	4/18/2024
4118215-01	1	4/19/2023	4/18/2024
4118215-01	1	4/20/2023	4/18/2024
4118215-01	1	4/24/2023	4/18/2024
4118215-01	1	4/25/2023	4/18/2024
4118215-01	1	4/27/2023	4/18/2024
4118215-01	1	4/28/2023	4/18/2024
4118215-01	1	5/3/2023	4/18/2024
4118215-01	1	5/5/2023	4/18/2024
4118215-01	1	5/8/2023	4/18/2024
4118215-01	1	5/10/2023	4/18/2024
4118215-01	1	5/12/2023	4/18/2024
4118215-01	1	5/15/2023	4/18/2024
4118215-01	1	5/16/2023	4/18/2024
4118215-01	1	5/18/2023	4/18/2024
4118215-01	1	5/22/2023	4/18/2024
4118215-01	1	6/1/2023	4/18/2024
4118215-01	1	6/5/2023	4/18/2024
4118215-01	1	6/6/2023	4/18/2024
4118215-01	1	6/7/2023	6/1/2023
4118215-01	1	6/8/2023	6/5/2023
4118215-01	1	6/9/2023	6/6/2023
4118215-01	1	6/13/2023	6/7/2023
4118215-01	1	6/13/2023	6/8/2023
4118215-01	1	6/14/2023	6/9/2023
4118215-01	1	6/16/2023	6/13/2023
4118215-01	1	6/19/2023	6/13/2023
4118215-01	1	6/20/2023	6/14/2023
4118215-01	2	4/26/2023	6/16/2023
4118215-01	1	6/27/2023	6/16/2023
4118215-01	1	6/29/2023	6/16/2023
4118215-01	1	4/26/2023	6/19/2023

[AppleUSN]

Hello Xiaoxin,

This did help me to find the solution.  I still had to dig deeper and create another measure to finish the formula but it did point me in the right direction.

Thanks again.

[Anonymous · Accepted solution]

Hi @AppleUSN,

Perhaps you can take a look at the Greg’s blog about some common usage scenarios if they meets to your requirements:

Before You Post, Read This: start, end date 
Regards,

Xiaoxin Sheng