Forum Discussion

smath's avatar
smath
Frequent Visitor
8 years ago

Help with a DAX function to acumulacte

I want to make a DAX measure such that for example in the next picture 

 

 

For each month accumulate the month valor in the blue bar, for example in 2017-2 shows 1758 + 1782, in 2017-3 1758+1782+1792.

Actually the measure for the blue bar is a simple count, then i need some method to save the past moth value for this count (can be a calculated table, etc) to make this or i think that.

Thank so much for your help.

Need Help

1 Reply

  • TomMartens's avatar
    TomMartens
    Super User
    8 years ago

    Hey,

     

    without having more details about your data model (is there a dedicated Calendar Table and stuff like that) it's really hard to provide a proper solution.

     

    I would give this a try

    Acumulated Measure = 
CALCULATE(
SUMX(
    FILTER(
        ALL('name of your facttable')
        ,'datetable'[datecolumn] <= MAX('datetable'[datecolumn])
    )
    ,[name of your measure]
)
)

    Maybe you will find some ideas on this side https://www.daxpatterns.com/ especially the part for date related calculations https://www.daxpatterns.com/time-patterns/

     

    Hope this gives you some ideas

     

    Regards

    Tom