***** Related Links ***** Forecasting Analysis Techniques In Power BI With DAX blog.enterprisedna.co/forecasting-techniques-in-power-bi-by-using-dax/ Creating Forward Forecasts In Power BI Using DAX blog.enterprisedna.co/create-dynamic-forward-forecasts-in-power-bi-w-dax/ Create A New Table In Power BI: How To Implement Budgets & Forecasts Automatically Using DAX blog.enterprisedna.co/create-and-set-budgets-automatically-in-power-bi-using-dax/ ***** Related Course Modules ***** Budgeting & Forecasting portal.enterprisedna.co/p/budgeting-and-forecasting DAX Formula Deep Dives portal.enterprisedna.co/p/dax-formula-deep-dives Mastering DAX Calculations portal.enterprisedna.co/p/mastering-dax-calculations ***** Related Support Forums ***** Predicting Future Years forum.enterprisedna.co/t/predicting-future-years/2112 Using Current Trend To Forecast Sales forum.enterprisedna.co/t/using-current-trend-to-forecast-sales/687 Maintain Forecast DAX Calculation In Different Context forum.enterprisedna.co/t/maintain-forecast-dax-calculation-in-different-context/5100 For more forecasting logic queries to review see here….. forum.enterprisedna.co/search?q=forecasting%20logic

Good Morning!! A help. I need to set up an income statement for the year (DRE) with a verifical analysis for each level, that is, each level must be 100% for the level below: The Gross Revenue Value must be fixed only in the cost / expense groups, the values ​​in the cost / expense groups must be fixed in the cost / expense subgroup and the values ​​in the cost / expense subgroup in the analytical accounts. This way I can do the proportion in each level of the DRE ... but I am BREAKING THE HEAD OF THIS Congratulations on the channel, excellent !!!

Hi! It is interesting. BUT, are you sure that a data of the last year is a forecast?

Thank you so much for your vídeos! it is so useful S2

Although I like the video contents, I think the term 'Advanced Forecasting' is a bit misplaced. The technics and formulas are nice, but you're 'just' plotting last year sales into the chart. No advanced forecasting analytics or technics used. Besides this, very usefull, and well explained!

nice but very simplified forecasting process that would be. In real life, forecasts are much more robust.

Sam it's amazing 👏

In some paper they have asked Which is not a forecasting technique Regression Time series HOLT & WINTER method Exponential smoothing Which option I need to select ??

Very powerful instruction thank you Sam. I concur with comments below re. forecast numbers: the example would be better illustrated if forecast amounts were unique - not a copy of the prior year's amounts. Also, I believe your tracking chart might be better illustrated if the formula were Sales vs Forecast - I am interested in how my cum sales is tracking against the forecast - if sales is less-than forecast (as it is from Jan to May) then I would expected the delta graph to be negative during that period. Still,,,,this is fascinating instruction - thanks very much.

How is Sales LY value for 2016 considered as Forecast? Am I missing something? Sales LY and 2016 Forecast both shows exactly the same value. I am confused. Can someone explain how this is predicting the data. This is not using any prediction if I am correct its simply getting the last year sales and plotting it onto 2016.

Why it doesn't look like a forecast to me? IFrom the DAX it looks like you already have data for 2016 in your tables. I think you are essentially calculating sales for 2016 using the 2016 sales data in the table. Not sure how the DAX for 2016 Forecast is projecting the values that is not there in the tables based on historical data. Correct me if I am wrong.

Hi Sam, thank you so much! Your videos are wonderful. However, is it possible if you demonstrate how to use DAX to perform an exponential smoothing forecast? That's what my company have always been using, and I need to translate that into Power BI.

I liked almost all of your videos, this is also good but you aren't calculating forecast in anyway. It's just that you have brought up some previous data against current data. It should follow some forecasting model to be called as forecast. But nevertheless it a good technique.

Great video! Thank you so much! I wonder how you make Power BI panel having dark theme ?

Please how do u calculate saisonality ?

Can you use this technique to go multiple years into the future?

Hi Sam, Love your tutorials. The business I work for closes at the weekend, so when I use the ISBLANK function I get gaps in the area chart. Any tips on how I can overcome this..

Thank you for a through video. I am trying to calculate the monthly forecast using monthly data that is in long form from an unpivoted excel table that does not use formulas to calculate the monthly data. The built in forecasting in Power BI is not what I need as I need the future spending numbers. Is there a video that goes into that?

one question here is if my ordinary date time line is only 2017, but I want to show the forecast in 2018. How shoud I use the method to do that?

Hello, again thanks a lot for your videos. Really amazing job. I have a question, I need to build a structured dashboard using different level of precision. Meaning for exemple that we start with the whole group and drilling down to different markets and then to different offices. How would you solve this matter? I know it is very complex, but it would be very powerfull to build this :-) Maybe you could do a small video to explain how the structure could look like :-) Thanks again Mark

is it possible to create our own slicers suppose 1.current QTD vs prior QTD 2. Current MTD vs Prior MTD and display the related visuals accroding to that?

Hi Sam, I have a question and I need your advice. I have data up to say june 2017. I want to get the data for one year from june-16 till june 2017 and shift date context so it becomes june 2017 - june 2018, to create a basic forecast. and then using the extra table for % growth I can show increase in percentages. my question is how to push the data forward in the time frame?

Hi, Thanks for the video. I am facing a problem. I have a data set with 12 months data of everyday sales of 5 regions and 16 products. I need to forecast that will indicate overall sales prediction for next three months, there must be a drill down capability of region and products. i.e. in the same graph i need to show forecast for each and every region and product using slicer. The data set is like this. everyday, more than one region, and more than 1 product have sales data. Please help me with this, i am stuck with this problem since last 2 weeks Thank You