Forum Discussion
Solved
Running total chart
Hello, I wanted to see if someone could help me create a running total chart. My fields are the following DATE , RANGE, CONTRIBUTIONS Any help would be greatly appreciated. Thanks, ...
Not much to go on, but you should be able to use the Cumulative Total pattern here I believe:
http://www.daxpatterns.com/cumulative-total/
Running total usually looks like this ...
CALCULATE ( SUM(TABLE[Contributions]), FILTER( ALL(DATE), DATE[Date] <= MAX(DATE[Date] ) )
OscJara Because you are working with week on week a date table will not help you
Read this solution here...
Yes Anonymous is absolutely right get rid of VALUES(...
Also you have an additional field in the Legend (breaking down the running total by something which will need to be addressed)
