Forum Discussion
Running total quarterly
Hi,
I am trying to calculate a running total and show this quarterly. I have the below figures which i want to show a cumulative total by Quarter so for Quarter 2, i want to see a total that includes Q1.
So i would like to see the following totals shown
Q1 = 24
Q2 = 95
Q3 = 222
Q4 = 396
I have tried different calculations based on other people's posts but cannot find an answer to this particular query. Is this possible?
kind regards
Hetal
Hi Anonymous ,
I created some data:
Here are the steps you can follow：
1. Create calculated column.
Quarter = QUARTER('Table'[date])2. Create measure.
Running total quarterly = CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[Quarter]<=MAX('Table'[Quarter])))3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
Anonymous , This seem like YTD, unless you want cross year and want cumulative
example
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uAHi Anonymous ,
I created some data:
Here are the steps you can follow：
1. Create calculated column.
Quarter = QUARTER('Table'[date])2. Create measure.
Running total quarterly = CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[Quarter]<=MAX('Table'[Quarter])))3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
