Overlay future forecast values over actuals on clustered column chart

[Anonymous]

Hello Community:   Below shows current YTD revenue and then our annual budget in orange.   This is fine, but what I also want to show is what the predicted values look like (our forecasts + our unshipped orders).    What I am trying to do, is to have these values be be additive to our current YTD....so that it in the visual it would  show as a continuation of the blue area (but probably in a slightly different color of course).    This way we can see our budget, our actual YTD, and what our predicted remaining year looks like.     I have the unshipped orders and forecasts, but currently they are "on the floor" of the visual, and do not show as addiditve. 

I essentially want a separate overlay that includes current YTD + forecasts + unshipped orders  (similar to how the budget is showing).     I have tried creating a simple measure adding in these things, but the result is what you see below.   It is not "adding" to the current YTD.   

[Asac_14]

Try creating a measure like if the date is less than Today() then YTD else YTD+Forecast+Unshipped. Use this new measure in your visual. Let me know if it works.

[Anonymous]

Thank you - That helped but still not quite where I need to be.   Here is the formula I used.   I did make one change to a formulat being used to make it cumulative.   You can see the difference in how the visual looks.   Since my YTD formula was cumulative, I needed the others to match it.   So the measure below (the "false"), is comprised of 3 cumulative measures (YTD, unshipped, and 80% forecast probability).    But they still are not "additive" to the existing YTD.   The measure just displays next to the YTD, rather than showing as a continuation into the future on top of the existing YTD.   

Rest of Year = IF( DATE(2025,12,31) < TODAY(),[YTD Revenue],[YTD Backlog 80])

[Anonymous · Accepted solution]

Hi Lin - I think I may have just figured it out. The orange is YTD. I changed my "unshipped" formula and included in it the YTD value. So that formula became Unshipped + YTD revenue). That allowed the blue part of the visual below to start at the same level (last day of YTD), and then start from there to show the rest of the year (unshipped + forecast). Was an obvious answer that I overlooked!