Cumulative Total from the dawn of time

[FrugalEconomist]

Hi PowerBI users,

I'm trying to add cumulative total, but it resets each year. Is it possible to have it continuos from the dawn of time? You can see that my graphs dip at the end of each year.

Thank you,

Kai

[FrugalEconomist · Accepted solution]

I figured it out with better googling:

https://javierguillen.wordpress.com/2011/12/13/rolling-sum-across-categories-that-are-not-dates/

A sample code might look like this

Running Total = CALCULATE(SUM(Query1[Sales]),
FILTER(
ALL(Query1[Date].[Date]),
Query1[Date].[Date]<=MAX(Query1[Date].[Date])
)
)

[v-ljerr-msft]

Hi @FrugalEconomist,

Great to hear the problem got resolved.Could you accept your reply as solution to close this thread?

Regards

[FrugalEconomist]

I figure it out! Found this resource with better googling: 

https://javierguillen.wordpress.com/2012/11/28/running-total-techniques-in-dax/

A sample code might look like this:

Running Total = CALCULATE(SUM(Query1[Sales]),
FILTER(
ALL(Query1[Date].[Date]),
Query1[Date].[Date]<=MAX(Query1[Date].[Date])
)
)