Forum Discussion

MattyH's avatar
MattyH
Frequent Visitor
5 years ago

Calculated Columns - Cumulative Totals problems

Hey Guys   Im trying to create YTD totals for daily hours (for people) in a calculated column using DAX. I can do it in M (see running total column) but want to do it in DAX.  I have an IF function...
Tanushree_Kapse's avatar
Tanushree_Kapse
Impactful Individual
5 years ago

Hi MattyH ,

Try using these measures for creating Running total:
1. Running total= CALCULATE(SUM(Financial[Hours]), ALLSELECTED(Dates)), Dates< = MAX( Date)))

Or

2. Running total= CALCULATE( SUM( Financial[hours]), FILTER( ALLSELECTED(Dates)), ISONORAFTER( Dates, MAX( Dates)), desc)))

 

 

I hope this helps!