Forum Discussion
Running Total
I have Measure Created for Total Saving and I would like to show the running total of Total Saving Total Saving in: Jan Jan + Feb Jan + Feb Mar and so on I have used the mentioned below...
Hi Anonymous ,
You may change the formula like DAX below.
running total measure =
CALCULATE (
SUM ( Table1[Sales] ),
FILTER (
ALLSELECTED ( Table1 ),
YEAR ( 'Table1'[Date] ) = YEAR ( MAX ( 'Table1'[Date] ) )
&& MONTH ( 'Table1'[Date] ) <= MONTH ( MAX ( 'Table1'[Date] ) )
)
)
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.