Following the guidance located in the revenue forecast technique here:
[Enterprise DNA Revenue Forecasting] (https://www.youtube.com/watch?v=t2JTOE76q0E&feature=youtu.be)
I’ve successfully created the measure for our project data which includes:
- Day Rate ($)
- Start Date
- End Date
However, I’ve been unable to create a cumulative total using the cumulative total pattern, which has worked for other entities as the values are lost when we change the time. I’ve seen a few other people ask the same question but haven’t been able to find a solution that works.
I am looking to calculate:
- Revenue per month (sum of all Day Rates for projects that are active for a given day for that month)
- Cumulative Total (YTD)
Thanks for your help!