Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Forecasting DAX

Hi, can someone help me with creating the DAX in PowerBI for this function - "FORECAST.ETS" that is used in Excel: https://www.excelfunctions.net/excel-forecast-ets-function.html   Thanks!
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I don't even see the Forecast option anymore. Any idea why?

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

Could you please check the type of "Date1" Column? Based on my test, it can works with the date type:

 


By the way, PBIX file as attached.


Best regards,

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi, sorry, I missed this. So I got it to work, but this Forecast feature in PBI is extremely limited 😞 For instance, line chart looks great with Date as axis, and Values in y-axis. But, if I want to slice the forecast values by another field, e.g. City, the forecast values disappear and line chart goes back to just showing actuals. Sad.