Forum Discussion
Using Prior Month Data to Build Future Month Data
I have three tables. One of inventory, one for demand, and one for anticipated orders. Inventory is simply the current amount of inventory held. Demand is the amount anticipated to be bought every mo...
lbendlin
Super User
Super UserThis is a cumulative function so you need to use one of the *X DAX features like SUMX , and table variables to hold the intermediate results.
Have you considered doing this in Power Query instead? It has a List.Accumulate() function specifically for this scenario.