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
LewisH's avatar
LewisH
Helper II
9 years ago

So We take the first month and we can see the Requested 78 - the Resolved 43 = 35.

In the second month we have 141 requested and 119 resoloved, leaving 22. So the new measure should show 35 + 22 = 57.

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

LewisH have you tried the above?

  • LewisH's avatar
    LewisH
    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's avatar
      vanessafvg
      Community Champion
      9 years ago

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

      • LewisH's avatar
        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]) )).