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

Sorry, I am lost. So what are you directing me to do?

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

    Got it. Thanks. I didn't see the link but see it now. Will go through it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    It seems that this applies to say a line graph with Year as axis. So if I want t use Date or Month then the Forecast option won't show up in the Analytics pane option 😞

  • 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.