Forum Discussion
Forecast with irregular dates
Anonymous,
Firstly, create a date table that contains all possible and continuous dates, then create relationship between the date table and your original table.
Secondly, merge the date table and your original table based on the date field into a new query.
Thirdly, create line chart using date key of merged table as X-Axis of Line chart, then you will be able to add forecast line. For more details about solving the above error, please review the following blog.
http://www.erikhudzik.com/2017/01/16/power-bi-forecasting-feature-and-when-your-data-is-too-irregular-to-forecast/
Regards,
Lydia
Anonymous,
Firstly, create a date table that contains all possible and continuous dates, then create relationship between the date table and your original table.
Secondly, merge the date table and your original table based on the date field into a new query.
Thirdly, create line chart using date key of merged table as X-Axis of Line chart, then you will be able to add forecast line. For more details about solving the above error, please review the following blog.
http://www.erikhudzik.com/2017/01/16/power-bi-forecasting-feature-and-when-your-data-is-too-irregular-to-forecast/
Regards,
Lydia
Hi Anonymous,
Thanks for the detailed information and the URL for the example. It looks like that will meet my needs pretty well.
Thanks again!
Jonathan
Hello Lydia, Can you show me where to merge the date table and original table based on the date field into a new query?
- Thanks! Works for me. Great explanation via the url.
