Create Automatic Forecasts From Historic Data in Power BI using DAX


A lot of times in business you will make your forecasts and budgets off historic data. In this video I show you how you can do just that using time intelligence functions in Power BI. Really shows you how powerful the DAX language can be where you can retrieve these results so quick and easy

*****Video Details*****
0:15 – Introduction
1:28 – How To Create Automated Forecast From Historic Data
4:35 – Using Variables To Create One Measure For A 3-Year Forecast
7:15 – Creating The Visualization

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

***** Related Links *****
Forecasting Analysis Techniques in Power BI with DAX
https://blog.enterprisedna.co/2019/03/13/forecasting-techniques-in-power-bi-by-using-dax/
Explore Forecasting Logic In Your Power BI Models Using DAX
https://blog.enterprisedna.co/2019/04/08/forecasting-techniques-in-power-bi-using-dax-formula/
Create Dynamic Cumulative Totals Using DAX In Power BI
https://blog.enterprisedna.co/2019/07/08/create-dynamic-cumulative-totals-using-dax-in-power-bi/

***** Related Course Modules *****
Budgeting & Forecasting
http://portal.enterprisedna.co/p/budgeting-and-forecasting
Solving Analytical Scenarios w/Power BI & DAX
http://portal.enterprisedna.co/p/solving-business-scenarios-with-power-bi-and-dax
Time Intelligence Calculations
http://portal.enterprisedna.co/p/time-intelligence-calculations

***** Related Support Forums *****
Cumulative Forecasting
https://forum.enterprisedna.co/t/cumulative-forecasting/151
Cumulative Total This Year vs Last
https://forum.enterprisedna.co/t/cumulative-total-this-year-vs-last/2713
Using Current Trend To Forecast Sales
https://forum.enterprisedna.co/t/using-current-trend-to-forecast-sales/687
For more forecasting queries to review see here…..
https://forum.enterprisedna.co/search?q=forecasting