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

Community Champion

9 years ago

LewisH have you tried the above?

Helper II

9 years ago

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

vanessafvg
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]))