Forecasting DAX

[Anonymous]

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!

[edhans]

Have you seen this article?

[Anonymous]

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

[edhans]

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]

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

[v-lid-msft]

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]

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.

[Anonymous]

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]

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