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