Hi Ashish, no it doesn't, if I have another value for SKU A in February 2018 (say 400), your measure totals up the inventory values for the past two months. which means the remaining inventory for February will become 900 - (28 + 22) = 850.
The february inventory data should override the previous inventory data and the calculation should be carried forward. I.e. the february forecast value should be 400-22 = 378, and march forecast should be 378 - 16 = 362 etc etc.
(I'm trying to use :
CALCULATE ( SUM ( Inventory[Qty] ) , LASTNONBLANK(...))
but I am still stumbling (I'm still quite new at DAX)).
I cannot quite appreciate your example. First, there should also be Purchases data. so that opening stock + Purchases - Sales = Clsoing stock. In your example, the inv qty for Feb should be 472-22=450.