CAGR HELP! Forecasting using Current data
I literally forgot how to do this, please help. I have a table that has 2018-2022 Year sales. I created a whatifparameter from 0-100% to be the CAGR value. Focusing only on 2022 sales, I want the user to be able to select their desired CAGR % and see what the how it impacts 2023-2025 forecasted sales. Forecasted Sales is dax table using Union Row...example below
