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] ) )
Running total usually looks like this ...
CALCULATE ( SUM(TABLE[Contributions]), FILTER( ALL(DATE), DATE[Date] <= MAX(DATE[Date] ) )
The numbers seem to be off slightly with this.
CALCULATE(SUM(Query20[NET_CONTRIBUTIONS]),FILTER(ALL(Query20[DATE]),Query20[DATE] <=MAX(Query20[DATE])))
Note that in the examples the last part with the filter for dates is filtering a separate date table. You need to add another table to your data model for this kind of time intelligence.
