Time Evolution of Inventory Using DAX

Running Inventory = 
CALCULATE(
    MAX('Table'[Current Inventory]),
    ALLEXCEPT('Table','Table'[Part Number])
)
-
CALCULATE(
    SUM('Table'[Demand]),
    FILTER(
        'Table',
        'Table'[Date]<=EARLIER('Table'[Date]) &&
        'Table'[Part Number] = EARLIER('Table'[Part Number])
    )
)

Hi， jt1999 ；

Create a measure by dax.

Runing Inventory = CALCULATE(SUM([Current Inventory])-SUM([Demand]),FILTER(ALL('Table'),[Date]<=MAX('Table'[Date])&&[Part Number]=MAX('Table'[Part Number])))

the final show:

Or create a column by dax.

Running Inventory = CALCULATE(SUM([Current Inventory])-SUM([Demand]),FILTER('Table',[Part Number]=EARLIER('Table'[Part Number])&&[Date]<=EARLIER('Table'[Date])))

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.