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
ajain_circle123
New Member

Issue in calculating cumulative value(runnig total)

Hi everyone, I am first timer here with my query, and I am stuck with below issue. Here my measure "Cumulative DefScheduledQty" is calculated wrong. I am using below formulas. Kindly suggest

 

DefSchedulesQty =
if(ISBLANK(sum(DefaultSchedules[Qty])), sum(schedule[BilledHours]), sum(DefaultSchedules[Qty]))

 

Cumulative DefSchedulesQty =
Var selectedDate = SelectedValue(DimDate[date])
Var Years = YEAR(selectedDate)
Return
Calculate( [DefSchedulesQty],Filter(ALLSELECTED(DimDate),DimDate[date]<=selectedDate))

 

ajain_circle123_0-1601926628546.png

 

2 REPLIES 2
daxer-almighty
Solution Sage
Solution Sage

Please use this website to get to know how to deal with time-related calculation IN THE RIGHT WAY: https://www.daxpatterns.com/time-patterns/

Helpful resources

Announcements
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!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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.