Forum Discussion
Running total
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?
did you try the running total? (i adjusted it slightly_
measure = calculate([request]-[resolved], filter(datetable, datetable[date] <= max(datetable[date]))
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.
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
Here you are.
Measure should read 35, 55, 50
Thanks for your help.
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??