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...
Need Help
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