Learn how your can project forward forecasts based on historical data and then also normalize the forecasts to account for seasonality in the numbers
*****Video Details*****
0:12 - Introduction
1:56 - Starting With The Core Measures
3:31 - Creating Forward Projection Using SAMEPERIODLASTYEAR
5:41 - Working Out Moving Average Of Total Profits
8:08 - Conclusion
***** 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 Technique: Exploring Forecasting Logic In Power BI Models
https://blog.enterprisedna.co/forecasting-techniques-in-power-bi-using-dax-formula/
Creating Forward Forecasts In Power BI Using DAX
https://blog.enterprisedna.co/create-dynamic-forward-forecasts-in-power-bi-w-dax/
Predict Future Profitability Within Power BI DAX Functions
https://blog.enterprisedna.co/predict-profitability-for-future-time-periods-with-power-bi-techniques/
***** Related Course Modules *****
Budgeting & Forecasting
http://portal.enterprisedna.co/p/budgeting-and-forecasting
Time Intelligence Calculations
http://portal.enterprisedna.co/p/time-intelligence-calculations
Solving Analytical Scenarios w/Power BI & DAX
http://portal.enterprisedna.co/p/solving-business-scenarios-with-power-bi-and-dax
***** Related Support Forums *****
Forecast For Future Period
https://forum.enterprisedna.co/t/forecast-for-future-period/1487
Forecast / Project Forward My Stock Inventory Value
https://forum.enterprisedna.co/t/forecast-project-forward-my-stock-inventory-value/4116
Trend Calculation That Ignores Date Slicer
https://forum.enterprisedna.co/t/trend-calculation-that-ignores-date-slicer/965
For more forward forecasting queries to review see here…..
https://forum.enterprisedna.co/search?q=forward%20forecasting