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
