I have a series of sales by week ending date, I want to forecast the cumulative sales specifically to 12/31/2023. I have created a running sum calculated field, but cannot figure out how to get the forecast to specifically project out to 12/31/2023 rather than just having to input the number of periods. As the data refreshes, I still want to project the EOY total.
I could also accept handling this in a custom narrative too.