Forum Discussion

LewisH's avatar
LewisH
Helper II
9 years ago

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...
Need Help
vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

LewisH

 

did you try the running total? (i adjusted it slightly_

 

measure = calculate([request]-[resolved], filter(datetable, datetable[date] <= max(datetable[date]))

LewisH's avatar
LewisH
Helper II
9 years ago

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. 

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    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

  • LewisH's avatar
    LewisH
    Helper II
    9 years ago

    Here you are. 

    Measure should read 35, 55, 50 

     

    Thanks for your help.