Forum Discussion
Solved
Cumulative turnover
Hello everyone I know that this topic has been discussed many times but I couldn't solve it. This is my database: I want to see cumulative turnover for current month - current year. I tr...
Heya,
Could you please try this:
Cumulative Turnover (forum) = CALCULATE( SUM(Table[Turnover]),FILTER(ALLSELECTED(Table),Table[Date]<=MAX(Table[Date])))If this solved your problem then please mark it as the solution so others can see it.
Best,
Try the attached file, the formula is fairly simple. I also added a Date table.
Cumulative forum =
CALCULATE(SUM(Sheet1[Turnover]),ALL(Sheet1),Sheet1[Date]<=MAX(Sheet1[Date]))
Cumulative forum PY =
IF([Cumulative forum]=BLANK(),BLANK(),
CALCULATE([Cumulative forum],SAMEPERIODLASTYEAR(Sheet1[Date])))
I've attached the updated file.
If this solved your problem then please mark it as the solution so others can see it.
Best,
Hi MNedix
No my point would be to have a table like this:
| Month | Day | Turnover Year | Turnover prev year | Cumulated year | Cumulated prev year |
| Aug | 30 | 100 | 80 | 0 | 0 |
| Aug | 31 | 60 | 100 | 0 | 0 |
| Sep | 1 | 20 | 90 | 20 | 90 |
| Sep | 2 | 70 | 60 | 90 | 150 |
| Sep | 3 | 100 | 50 | 190 | 200 |
But (using your formulas with some adjustment) I only get this:
With the PY formula that is already considering all the cumulated value.
I hope it's clearer now 🙂
Thanks again!