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