Forum Discussion
Get commulative total last year until December only
I want to get the commulative total of last year's data until december 31 only, regardless of the current month/year I selected in the charts. Below is the formula I used to get the commulative t...
v-xuding-msft
Community Support
Community SupportHi JazZ0003 ,
Please try this:
lastyear = CALCULATE(SUM(financials3[Sales]),DATEADD(financials3[Date],-1,YEAR))Running total = CALCULATE([lastyear],FILTER(ALL(financials3),financials3[Date] <= MAX(financials3[Date])))
thank you v-xuding-msft
But most of your solutions focused on previous year only. I need to compute the running total since from the beggining of data, not only previous year.
This is what I want to acheive, running total from all the data from all prevous year upto last year december.
This would be the outcome.
https://drive.google.com/file/d/1ka6IgcOauj1dNck3M9rawsHewF-kHxIJ/view