Forum Discussion
Cumulative Total
Filtering all Finance Table (not only a column), I get the Cumulative for the month, but if you have duplicate dates, the cumulative will be the same, in both.
Cumulative = CALCULATE(
SUM(Finance[Column CC])
,FILTER(ALL(Finance), Finance[Date] <= MAX (Finance[Date])))
I think your formula is correct, so could you please provide more information:
- Control you are using (charts/table/matrix)
- Sample data
The data is coming from each centre and is collected once every month and is split by Actual and Budget.
Centre
Date
Income
Staff
Agency
Other costs
Act/Bud
1
31/03/2015
-2000
200
200
122
Act
2
31/03/2015
-4000
100
100
100
Act
1
31/03/2015
-2000
200
200
122
Bud
2
31/03/2015
-4000
100
100
100
Bud
1
30/04/2015
-2000
200
200
122
Act
2
30/04/2015
-4000
100
100
100
Act
1
30/04/2015
-2000
200
200
122
Bud
2
30/04/2015
-4000
100
100
100
Bud
The data is mocked up but you get the general idea.
To get the Column CC I created a cal column which is Column CC = (-Finance[Income] - Finance[Staff] - Finance[Agency]- Finance[Other costs])
I am using bar graph.
I hope it is clear, if not let me know.
You need to add one more Dates table and link your date column to this date:
Refer: https://community.powerbi.com/t5/Desktop/DAX-How-to-perform-a-cummulative-summation/td-p/7378
tringuyenminh92 I dont understand why I need to create another date table when I do have one already.
