Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Forecasting DAX

‎03-30-2020 04:31 PM

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!

Labels:
Message 1 of 9
6,164 Views
0
8 REPLIES 8
edhans
Super User
Super User

‎03-30-2020 04:39 PM

Have you seen this article?



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Message 2 of 9
6,161 Views
0
Anonymous
Not applicable
In response to edhans

‎03-30-2020 04:41 PM

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

Message 3 of 9
6,159 Views
0
edhans
Super User
Super User
In response to Anonymous

‎03-30-2020 04:44 PM

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Message 4 of 9
6,154 Views
0
Anonymous
Not applicable
In response to edhans

‎03-31-2020 09:15 AM

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

Message 7 of 9
6,098 Views
0
v-lid-msft
Community Support
Community Support
In response to Anonymous

‎03-31-2020 11:20 PM

Hi @Anonymous ,

 

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

 

4.jpg


By the way, PBIX file as attached.


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Forecasting-DAX.pbix
Message 8 of 9
6,087 Views
0
Anonymous
Not applicable
In response to v-lid-msft

‎04-24-2020 02:46 PM

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.

Message 9 of 9
6,073 Views
0
Anonymous
Not applicable
In response to edhans

‎03-30-2020 04:59 PM

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 😞

Message 6 of 9
6,145 Views
0
Anonymous
Not applicable
In response to edhans

‎03-30-2020 04:47 PM

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

Message 5 of 9
6,152 Views
0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All