CAGR not working as expected
Hi, I have a CAGR calculation but the outcome is not as expected, I expect to have different CAGR for different countrys and formats (other dimensons might be used as well to show more granularity, like customer, market area, ...: This is the formular for one of the columns: Net Sales Sleeves CAGR_2024_to_2028 = VAR InitialValue = CALCULATE( SUM('Table_Sleeves'[Net Sales Sleeves EUR]), FILTER( ALL('Table_Sleeves'), YEAR('Table_Sleeves'[Date]) = 2024 ) ) VAR FinalValue = CALCULATE( SUM('Table_Sleeves'[Net Sales Sleeves EUR]), FILTER( ALL('Table_Sleeves'), YEAR('Table_Sleeves'[Date]) = 2028 ) ) VAR NumberOfYears = 2028 - 2024 RETURN IF(InitialValue = 0, BLANK(), (FinalValue / InitialValue) ^ (1 / NumberOfYears) - 1) Great if someone can support me and fix my formular. Thank you very much.
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
