Forum Discussion
Solved
Cumulative Amounts
Hi everyone! I am trying to calculate the cumulative sums of amounts in different months within a year. In excel, I would do so by locking the first value in the first month of interest and then ...
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/
Many thanks for your input.
I tried out the formula on my data/table. The formula seems to indeed add values for the respective month, however does not add them to the previous ones. So, for July, it yields the sum of all values in July. For August, it yields all values in August, but does not include July ones.
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/