Forum Discussion

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...

Helper II

9 years ago

I got this result which appears to be calculating the difference but not applying this to the previous difference.

Community Champion

9 years ago

LewisH which one did you use? please specify how you wrote the measure it required adjsutment probably

LewisH
Helper II
9 years ago
I used
Qty. Live = (([request] - [resolved]) + CALCULATE([request] - [Resolved], PREVIOUSMONTH(DateKey[Date]) )).

I guess it's this part which I'm not understanding correctly..
CALCULATE([request] - [Resolved], PREVIOUSMONTH(DateKey[Date]) )).
LewisH
Helper II
9 years ago
If I was to use this
Qty. Live2 = (([request] - [resolved]) + CALCULATE([request] - [Resolved], PREVIOUSMONTH(DateKey[Date]) ))
How can I chage this to only apply when the value's (Request and Resolved) aren't both blank?
- 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
    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.