How To Create Automated Forecast From Historic Data
forecast is derived from your historical results. So I’m going to show you how you can quickly grab historic data, consolidate it, and then create a forecast from it, which is still align to your entire data model. Let’s assume that we already have say some sales information already and we have our Sales calculation here. So we need to find a way to project forward to 2018. We want to work out our sales forecast in 2018. If you look at this filter down on the right-hand side, I’ve actually filtered for only 2018, so we’re only looking at 2018 here. To get in-Depth knowledge on Power BI you can enroll for a live demo on Power BI online training Now we create another measure table by clicking on Enter Data and it will give you the option to create a measure table. Let’s call this table Sales Forecasting . If you can get into the habit of creating these measure tables, it would benefit you immensely in terms of organizing your mode...