Forum Discussion

PBI_1107's avatar
PBI_1107
Frequent Visitor
2 years ago

Calculation for Cumulative Schedules and Inventory

Hello Everyone, I am stuck with a calculation where There is Current Inventory (2G3GCurrentInv), followed by months and the Schedules that are there for the specific ID's.   I want a Runnin...
PBI_1107's avatar
PBI_1107
Frequent Visitor
2 years ago

I used this DAX Query :

 

and got this Result :

It is adding up the Schedules from the 2g3GCurrentInv, it does not have like a running total. 
It should be like Oct 23 Inv = Sep 23 Inv + Oct Schedules, Nov 23 Inv = Oct Inv + Nov Schedules, Dec 23 Inv = Nov 23 Inv + Schedules, Jan 24 Inv = Dec 23 Inv + Jan Schedules.... and so on and so forth.
Please let me know, 

Thanks,
PBI_1107