Forum Discussion

newbie9292's avatar
newbie9292
Helper II
5 years ago
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 ...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    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's avatar
newbie9292
Helper II
5 years ago

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

Fowmy's avatar
Fowmy
Super User
5 years ago

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's avatar
    newbie9292
    Helper II
    5 years ago

    Hi,

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