Forum Discussion
Running Total Help
Hello! I have a data set that looks like this: Where Demand = WeeklyTriggerHrs + TotalHoursCurrent + TotalHrsPastDue AvgHoursPW = (Sum of run_mch_hrs_per_day)*6 Demand-HoursPW = Demand - A...
MichelleRoberts based on this data, this formula works for me:
CumulativeDemandHoursPW =
VAR CurrentYearWeek = SELECTEDVALUE('Table'[Year-Week])
RETURN
CALCULATE(
SUM('Table'[Demand-HoursPW]),
FILTER(
ALL('Table'),
'Table'[Year-Week] <= CurrentYearWeek
)
)
BBF
I see that it works for you but it's still not working for me. I'm going to try something else.
MichelleRoberts can you upload the pbix in drive and share the link? so that i can work on your version.
BBF