Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!