Forum Discussion
Running total chart
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)
Adding a week column to a date table is not a problem. There are lots of examples of custom date tables with weeks.
The easiest way is to add a custom column in the query editor that gives the date of the end of the week. The formula is = Date.EndOfWeek([Date])