Forum Discussion
Vijaykumar_shan
2 years agoFrequent Visitor
Running total
Hello, How to get running total to start where Expected is not blank Year Month Actuals Expected Running total_actual 2023 January 7329305.26 2023 February ...
Daniel29195
2 years agoCommunity Champion
assuming you have a dimdate table :
create the below measure
m =
var res =
var mind= calculate(
min(dimdate[date]) , allselected(dimdate), not isblank(tbl_name[excpected] ))
var maxd= calculate(
max(dimdate[date]) , not isblank(tbl_name[excpected] ))
var res =
calculate (
sum(tbl_name[actual]) ,
dimdate[date] >=mind , dimdate[date<=maxd , removefilters(dimdate)
)
return res
let me know if it works for you.
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠