Forum Discussion
Running total
I have a table called 'Service Desk List'. I Have two Measures which are Request = COUNTROWS('Service Desk List') Resolved = calculate(countrows('Service Desk List'), userelationship('Service Desk...
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
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.