Get Running Total of a Table on Multiple Criteria
I have a Calculated Column that keeps running out of memory when trying to calculate the running total of the table based on two different criteria. If I remove one of the criteria it runs fine.
Is there an easier way to calculate the running forecasted daily depletions with the same item and the posting week day less than the current row being calculated?
var item1 = 'Forecast'[item] var date2 = 'Forecast'[Week Day] return calculate(sum('Forecast'[Forecasted Daily Depletion]),'Forecast'[Week Day]<date2,'Forecast'[item]=item1)
Posted Feb 16, 2026, 8:27 PM UTC
22