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...
sorry my bad i left out the all
measure = calculate([request]-[resolved], filter(all(datetable), datetable[date] <= max(datetable[date]))
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.
LewisH is there any chance you can share your pbix with me? you can send it to me privately
Yes sure, where can I send it?
However my data comes from Navision, so I don't know how you would connect / get the data??