Forum Discussion

RayMundo00's avatar
RayMundo00
Regular Visitor
3 years ago

Rolling Stock based on Demand (Inventory Evolution)

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

 

 

 

Need Help
Show and Tell
Tutorial Requests

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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