Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingSorry, I am lost. So what are you directing me to do?
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI don't even see the Forecast option anymore. Any idea why?
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,
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.
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 😞
Got it. Thanks. I didn't see the link but see it now. Will go through it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |