Though out 2021, we will reforecast after every month. The Name of each forecast will be like this; “1+11” - It will have Jan 2021 with all zero’s, but the next 11 months will have forecasts. “2+10” = It will have Jan and Feb 2021 with all zero’s, but the next 10 months will have forecasts…and so and will end at “11+1” - first 11 months will have all zero’s with forecasts for Dec 2021. All of these multiple forecasts will be rolled up into on file.
I created a measure that totals the forecasts, and I have a measure that will display my actuals.
We want to select “1+11” in Feb and see the Actuals for Jan and the forecasts for the rest of the year from the “1+11”. When we click on “2+10” in March, we want to see actuals for Jan and Feb and the forecasts for the rest of the year from the “2+10”.
Please review the image I posted. I need a measure that says: If the forecasted total from the month/year equals zero, then give me actuals, if the forecasted total for the month/year is greater than 1, give me forecasts.
When we are in October, we still want to click on “1+11” and just see actuals for Jan and our forecast for the rest of the year from the “1+11” portion of the forecast. So, the measure can not ask, if actuals exist, give me actuals, else forecasts. I hope this makes sense. Thanks for the help.