Rolling Stock based on Demand (Inventory Evolution)

[RayMundo00]

Hi Everyone

I wish to know how we can calculate Running stock column Desire table (see image), In this example I know the current 'Qty On Hand for item 'A' and the Demand per date, I'd like to calculate a measure called Rolling Stock (see image). I've seen other similar posts here but I can't replicate the measures.

The key column between 'Demand' and 'Warehouse' tables is item column. The Demand table is linked to a Calendar table.

I hope you can help.

Thanks in advance

[amitchandak]

@RayMundo00 , refer my measures using date table

Inventory / OnHand

CALCULATE(SUM(Table[Ordered]),filter(date,date[date] <min,date[date]))) -
CALCULATE(SUM(Table[Sold]),filter(date,date[date] <min,date[date])))

Power BI Inventory On Hand: https://youtu.be/nKbJ9Cpb-Aw