Forecasting the data

[Anonymous]

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?

[Anonymous · Accepted solution]

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 2^nd 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.

[Pragati11]

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