Forum Discussion
Solved
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
Hi 7ballp25
Here is a sample file with the solution https://we.tl/t-UvJsRpmiYdForcasted Sales = VAR LastAvialableYear = MAX ( Data[Year] ) VAR LastAvailableSales = CALCULATE ( SUM ( Data[Sales] ),'Data'[Year] = LastAvialableYear ) VAR CurrentYear = MAX ('New Data'[Year] ) VAR YearDifference = CurrentYear - LastAvialableYear VAR SelectedPercent = SELECTEDVALUE ( Parameter[Selected %] ) RETURN LastAvailableSales * POWER ( 1 + SelectedPercent, YearDifference )
1 Reply
Hi 7ballp25
Here is a sample file with the solution https://we.tl/t-UvJsRpmiYdForcasted Sales = VAR LastAvialableYear = MAX ( Data[Year] ) VAR LastAvailableSales = CALCULATE ( SUM ( Data[Sales] ),'Data'[Year] = LastAvialableYear ) VAR CurrentYear = MAX ('New Data'[Year] ) VAR YearDifference = CurrentYear - LastAvialableYear VAR SelectedPercent = SELECTEDVALUE ( Parameter[Selected %] ) RETURN LastAvailableSales * POWER ( 1 + SelectedPercent, YearDifference )