Measure for Projected Annual Sales

[LarsAustin]

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

[LarsAustin]

Impressive..

Thanks so much Amit.

LarsAustin

[amitchandak · Accepted 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])

[LarsAustin]

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