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...
Thank you for this response. I've applied this and it gives me this result
The first Date (35) Is correct. However I would expect the second Date to say 55 as it should get the new total (Requested - Resolved) as it does but then apply the 35 from the previous month into the calculation. I hope that makes sense. Thsi way we can see the Live differercne betwen them and hopefully see it go down over time.
LewisH can you change the results to a table so i can see what its doing, also put the request and resolved amounts in
so
date, requested, resolved, cummulative measure in a table format thanks