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.
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 text in blue is the calculation 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
LarsAustin
Solved! Go to Solution.
@LarsAustin , Try a measure like. I have not tested this
maxx(all(Table), Table[Base Forecast])* PRODUCTX(filter(allselected(Table), Table[Year] <=max(Table])), 1+ [WIF Growth Rate])
Impressive..
Thanks so much Amit.
LarsAustin
@LarsAustin , Try a measure like. I have not tested this
maxx(all(Table), Table[Base Forecast])* PRODUCTX(filter(allselected(Table), Table[Year] <=max(Table])), 1+ [WIF Growth Rate])
Hi Amit,
Just one modification in my problem. Is it possible to amend the measure and instead of using the values on column WIF Growth Rate, it will be now based on values set as different individual parameters as below? I expect to still get the same end result.
Thank you
LarsAustin
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |