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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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