Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
smath
Frequent Visitor

Help with a DAX function to acumulacte

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

 

ayuda.jpg

 

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.

1 REPLY 1
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors