Hi all - based on spreadsheet below. I have the Sales data for 2019 & 2020
However I do not have the 2021 sales data.
I intend to calculate an estimate based on the prior year.
I calculated the following measures:
Sales TY vs LY
YoY Sales Growth
2021 Sales Budget (Column E4) should be a calculation of the YoY growth rate multiplied by the Sales LY
My question is how do I create a measure for this.
An option is to hardcode the number eg Sales Budget = [Sales LY] * 1.44
However I do not want to use hard numbers in my calculations
I also tried this measure:
Sales Budget = [Sales LY] * ( 1 + [YoY Sales Growth] ) and this did not work. The YoY sales growth came up with 0.0
Please your suggestions would be welcome