Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

0

Power BI Visual Forecasting vs Excel Forecasting Algorithm Difference

I am trying to work out why there is a difference between the Power BI visual forecasted values and the Excel forecasted values. The same set of data is being used and all settings appear to be the same. Does anyone have any idea as to the reason, or understand the different algorithms being used? #powerbi #data #forecasting #sec #budgeting #Excel #visualizations #revenue #mergersandacquisitions #financialreporting #accountants #regulation #forecast #projection #cfo

 

PowerBiExcelFroecasting.jpg
Status: Delivered

For about Power BI forecast line calculation, you can refer this video which introduces using DAX to forecast data in Power BI Desktop:

How to forecast data using DAX in Power BI? | Forecast Data in Power BI | DAX | BI Consulting Pro 

 

For about Excel forecast, you can refer this article which introduces how is Excel forecast calculated:

Excel FORECAST and other forecasting functions with formula examples 

 

Best Regards,
Community Support Team _ Yingjie Li

Comments
v-yingjl
Community Support
Status changed to: Delivered

For about Power BI forecast line calculation, you can refer this video which introduces using DAX to forecast data in Power BI Desktop:

How to forecast data using DAX in Power BI? | Forecast Data in Power BI | DAX | BI Consulting Pro 

 

For about Excel forecast, you can refer this article which introduces how is Excel forecast calculated:

Excel FORECAST and other forecasting functions with formula examples 

 

Best Regards,
Community Support Team _ Yingjie Li