Forum Discussion
Running Total
Hi guys, I have the below graph and I want to show the running total in it. Please let me know the best approach for this. i mean the open ticket for Dec should be 98, for Jan it should b...
Try:
Running Total Closed1 =
CALCULATE (
[Non-Dev Tags],
FILTER (
ALL('DAX Date Table'),
'DAX Date Table'[Date] <= max('DAX Date Table'[Date])
)
)No This is giving extremely wrong numbers.
I tried using the measure:
Running Total Closed =
CALCULATE(
[Non-Dev Tags]-[no of tickets by closed date],
FILTER(
ALLSELECTED('devops-query-spr2'[Created Date]),
ISONORAFTER('devops-query-spr2'[Created Date], MAX('devops-query-spr2'[Created Date]), DESC)
)
)
This is giving the difference of the two but i want to add the previous month's result to this result as well like Jan should be 98+46 = 144.
I have tried couple of things but its not working š