Forum Discussion
Power BI Forecasting in Excel
Hi jmckentr,
In Excel, if you have historical time-based data, you can use it to create a forecast. When you create a forecast, Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. You can refer to this blog: Create a forecast in Excel 2016 for Windows to get detailed steps.
Below articles describe the formula syntax and usage of the FORECAST function in Microsoft Excel.
If you still have any quesion about how to correctly create a forecasting report in Excel, I would suggest you post your questions on more related forum so that you can get more help.
Best regards,
Yuliana Gu
Hi jmckentr,
In Excel, if you have historical time-based data, you can use it to create a forecast. When you create a forecast, Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. You can refer to this blog: Create a forecast in Excel 2016 for Windows to get detailed steps.
Below articles describe the formula syntax and usage of the FORECAST function in Microsoft Excel.
If you still have any quesion about how to correctly create a forecasting report in Excel, I would suggest you post your questions on more related forum so that you can get more help.
Best regards,
Yuliana Gu
Perhaps my question was misworded. I know how to forecast in excel, is there an excel formula which results in the same forecasting numbers that power bi comes up with. To simplify it, does power bi use the same logic as excel?
I will also go to the excel forum to ask this same question since its divided between the two applications.
Hi jmckentr,
So, you want to get the same forecast result/values in Excel as that in Power BI, right? It would be better that you can share some sample data and your desired output.
Regards,
Yuliana Gu
