Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @7ballp25
Here is a sample file with the solution https://we.tl/t-UvJsRpmiYd
Forcasted 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 )
Hi @7ballp25
Here is a sample file with the solution https://we.tl/t-UvJsRpmiYd
Forcasted 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 )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
52 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
75 | |
58 | |
47 | |
16 | |
12 |