Forum Discussion
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...
LewisH add to what of the previous month?
something like this?
measure = (([request] - [resolved]) + calculate([request], previousmonth(datetable[date])) )
(for the second part of the statement where there is calculate you need to be specific of what you want to add it to
however if you wanting a running total
for example
measure = calculate([request], filter(datetable, datetable[date] <= max(datetable[date]))