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
edhans's avatar
edhans
Community Champion
6 years ago

Click on a link about forecasting in Power BI. There is no Forecast.ETS function, but it does have some forecast capabilities, as described in that article.

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.