Help with cummulated data

[newbie9292]

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]

@Fowmy  Thanks for your reply. But then how do I carry forward the cummulative balance in June to the other months?

[Fowmy · Accepted solution]

@newbie9292 

I am not sure how your formula is built but you can follow teh following pattern

Cumm = 

CALCULATE(
    SUM(financials[ Sales]),
    FILTER(
        ALLSELECTED(Dates),
        Dates[Date] <= MAX(Dates[Date])))

[newbie9292]

Hi,

This solved my issue. Thanks for all the help.🙂

[Fowmy]

@newbie9292 

Click on the Year Month field and choose Show Items with No Data