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 which one did you use? please specify how you wrote the measure it required adjsutment probably

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.
  - 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
- vanessafvg
  Community Champion
  9 years ago
  LewisH
  
  sorry my bad i left out the all
  
  measure = calculate([request]-[resolved], filter(all(datetable), datetable[date] <= max(datetable[date]))
  - LewisH
    Helper II
    9 years ago
    Thnak you again for your help, hopefully we will get there. I'm personally confused on what to do next. I have been left with this.
    The first data Entry is in April, previous dates should be ignored.