Forum Discussion
Forecasting with irregular dates
Hi Experts I have a data set going back 10 years with a sales value for each date of a sale. Unfortunately there is not a sale every day, so the dates are irregular which means I get the "Forecas...
Hi， easyleesie
As mentioned by amitchandak and mwegener ,you need to create a date table that contains regular dates, then create relationship between the date table and your original table.
Then please merge the date table and your original table based on the date field into a new query. Using date key of merged table as X-Axis of Line chart to create line chart , you will be able to add forecast line.
You can also check these related thread and post.
https://community.powerbi.com/t5/Desktop/Data-is-irregular-to-forecast-in-Power-BI-Desktop/m-p/781778
http://www.erikhudzik.com/2017/01/16/power-bi-forecasting-feature-and-when-your-data-is-too-irregula...
Best Regards,
Community Support Team _ Eason