first add three years in your db with no data and then do the calculation
IF ISNULL(SUM([Sales])) THEN PREVIOUS_VALUE(SUM([Sales]))*(1+[Uplift on Actual])
I'm not sure how you decide the target, but if we call the projected sales using past growth and some adjustment, attached will work.
Basically this replicates what we usually do on Excel.
1. Create new measures of the sales in each year
2. Calculate growth rate
3. Create parameter to control the adjustment (if necessary)
4. Apply 2 & 3 on the sales of the last actual year
target.twbx 400.4 KB
Thank you very much. It helped me a lot.
Thank you very much. It works.
One more question. How to forecast when you know CAGR