Forum Discussion
Running total
LewisH add to what of the previous month?
something like this?
measure = (([request] - [resolved]) + calculate([request], previousmonth(datetable[date])) )
(for the second part of the statement where there is calculate you need to be specific of what you want to add it to
however if you wanting a running total
for example
measure = calculate([request], filter(datetable, datetable[date] <= max(datetable[date]))
So We take the first month and we can see the Requested 78 - the Resolved 43 = 35.
In the second month we have 141 requested and 119 resoloved, leaving 22. So the new measure should show 35 + 22 = 57.
LewisH have you tried the above?
I got this result which appears to be calculating the difference but not applying this to the previous difference.
