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])))
Fowmy's avatar
Fowmy
Super User
5 years ago

newbie9292 

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