Forum Discussion
Cumulative Amounts
You can do something like this YTD calculation. If you need it to cover different custom calendars, jsut add a custom calendar.
https://blog.crossjoin.co.uk/2009/12/01/first-steps-in-dax-year-to-date/
If your data table is similar to below one. You should get the expected result with following measure provide by KGrice.
If you still cannot get it to work, could you please provide some sample data to us so that we can give an exact formula?
Running Total =
CALCULATE (
SUM ( Table2[Value] ),
FILTER ( ALL ( Table2 ), Table2[Date] <= MAX ( Table2[Date] ) )
)
Best Regards,
Herbert
Super thanks for all of your comments, appreciate it. I eventually managed to work it out with TOTALYTD. But I also had to fix the date measure, as it was highlighted in your answers. Without a proper date, in fact, I was not able to pick up the right data - this is so as eventually my data set ended up having multiple years.
Thank you all for your input :)
