Forum Discussion
Solved
Help with cummulated data
Hi,
I am trying to create a report and want cummulated figures for each month.
This how it looks at the moment
But my desired output is:
| Month Name | Kum_AE |
| January | 539,294.19 |
| February | 1,877,692.36 |
| March | 2,643,781.88 |
| April | 3,552,421.63 |
| May | 3,780,571.37 |
| June | 5,674,237.05 |
| July | 5,674,237.05 |
| August | 5,674,237.05 |
| September | 5,674,237.05 |
| October | 5,674,237.05 |
| November | 5,674,237.05 |
| December | 5,674,237.05 |
I have a date_dim table and the other data table which has only data till June. So for the rest of the months it should copy the cummulated value till June.
newbie9292
I am not sure how your formula is built but you can follow teh following patternCumm = CALCULATE( SUM(financials[ Sales]), FILTER( ALLSELECTED(Dates), Dates[Date] <= MAX(Dates[Date])))
4 Replies
Fowmy Thanks for your reply. But then how do I carry forward the cummulative balance in June to the other months?
newbie9292
I am not sure how your formula is built but you can follow teh following patternCumm = CALCULATE( SUM(financials[ Sales]), FILTER( ALLSELECTED(Dates), Dates[Date] <= MAX(Dates[Date])))Hi,
This solved my issue. Thanks for all the help.🙂
