Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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