Forecasting function not available in Analystics tool

[lucverg]

Good afternoon,

The forecasting function does not appear in the report below. I read all the post related to that issue but it did not help my case.

Could somebody help me?

Thanks in advance

[v-shex-msft]

Hi @lucverg,

Can you please share some sample data for test.

AFAIK, current forecasting feature only works on numeric and date type axis with regular records.

Regards,

Xiaoxin Sheng

[lucverg]

Thanks for your prompt answer.

I attached 3 screen shots to illustrate the data set used. The X - axis are dates type and the Y axis are calculate measures (Qty) and are integer type.

X- Axis - DateY axis - Qty (calculated measure)Graphic

[v-shex-msft]

HI @lucverg,

It seems like your records are irregular so forecast feature not activated on your side.

Regards,

Xiaoxin Sheng

[lucverg]

I created a calendar table that I linked with the "requested receipt" dates in order to smothen the intervals. But it stil does not work. I guess that I have to generate the forecast myself using DAX formulas? 

[v-shex-msft · Accepted solution]

HI @lucverg,

Nope, dax not support forecasting, maybe you can try to r visual with forecasting pack.

Dynamic Forecasting With Power BI And R

Regards,
Xiaoxin Sheng

[lucverg]

Thanks for your help. 

[ChrisMendoza]

@lucverg,

I recall that when I had the same issue it was due to not using the dCalendar[Dates] in the x-axis. Somewhere (an article I found) there is a statement saying you need a continguous date range. Try using that instead of using what looks like your transactional dates.

[lucverg]

Thanks for the tip I will check and let u know if it works.