Forum Discussion
Forecasting the data
Hi All,
I'm getting the below error while trying to forecast data but couldnt see any anormility in my dataset.
Can someone help here?
Hi Anonymous ,
Have you solved your problem? If not, please refer to the following blog.
- Merge in another data set with all possible dates for the date range I wanted for the report, then use the dates from that 2nd data set for the X-Axis so every date in the range would have a data point.
- On the Merge dialog box, shown below, we select our Join/Merge key (ExcelNumericDate), and select our “Join Kind”, eg: INNER, LEFT, RIGHT etc… Be careful here to pick the correct type of join, Right or Left, depending on which order the data sets are in.
More details: when your “Data is too irregular to forecast
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
HI Anonymous ,
I am not able to replicate this issue at my end as I can create forecasting.
There is an existing thread on the forum for this. See if it helps:
https://community.powerbi.com/t5/Desktop/Forecast-with-irregular-dates/m-p/238428
Hi Anonymous ,
Have you solved your problem? If not, please refer to the following blog.
- Merge in another data set with all possible dates for the date range I wanted for the report, then use the dates from that 2nd data set for the X-Axis so every date in the range would have a data point.
- On the Merge dialog box, shown below, we select our Join/Merge key (ExcelNumericDate), and select our “Join Kind”, eg: INNER, LEFT, RIGHT etc… Be careful here to pick the correct type of join, Right or Left, depending on which order the data sets are in.
More details: when your “Data is too irregular to forecast
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
