Measure for Projected Annual Sales

[LarsAustin]

Good Evening.



Is it possible to create a DAX measure to return projected sales based on projected growth rates?



I have the figures in columns Year, Base Forecast and WIF Growth Rate. I want the column WIF Forecast as a measure to return the values under it. The numbers in the rightmost column are the calculations if created manually in Excel.

Year	Base Forecast	WIF Growth Rate	WIF Forecast
2021	100
2022		30%	130	>>> 100 X 30%
2023		25%	162.5	>>> 130 X 25%
2024		10%	178.75	>>> 162.50 X 10%
2025		60%	286	>>> 178.75 X 60%

Thank you



Lars