Forum Discussion
Cummulative Toatl from Current Month Forward
Hello,
What my measure needs to do:
I need to calculate the cummulative total from the current month forward. However, I need this calculation to start at the latest value of the previous month of another separate measure.
| March 2020 | X | Y | NeededMeauser |
| April 2020 | 15 | ||
| May 2020 | 22 | ||
| June 2020 | 25 | 25 | |
| July 2020 | 16 | 16 + ( 25 ) | |
| Aug 2020 | 80 | 80 + ( 16 + 25 ) | |
| Sep 2020 | 91 | 91 + ( 80 + 16 + 25 ) |
3 Replies
Will "current month" always be defined by the clock? IE on July 1st will you no longer consider the June numbers?
Also, when does it end? At the end of the year or at the end of your data?
Yes, current month of TODAY()
I apologize, didn't see the last part there.
The data ends at the final date of the current filtered project. So, it is variable.
