Forum Discussion

ashleylarsen's avatar
ashleylarsen
Frequent Visitor
7 years ago
Solved

Use the most recent available value in forecasting formula with future dates

Hello,   I am trying to use the most recent value (date is 2017) in a formula to obtain a forecast for 2018, 2019 and 2020. Right now, the only way I am able to get the forecast to work is to cr...
Need Help
ashleylarsen's avatar
ashleylarsen
Frequent Visitor
7 years ago

Thanks v-chuncz-msft ,

 

This worked well with my measures. It took me a while to understand what's being done. It's that first line,
VAR y = SelectedValue(DATE)  combined into the Filter, FILTER(ALLSELECTED(DATES), DATES <= y), which means that the date changes dynamically.

 

Great help!