Cummulative Toatl from Current Month Forward

[dspringdev]

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 )

[lbendlin]

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?

[dspringdev]

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.

[dspringdev]

Yes, current month of TODAY()