Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
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.
HI @lucverg,
It seems like your records are irregular so forecast feature not activated on your side.
Regards,
Xiaoxin Sheng
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?
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
Thanks for your help.
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.
Proud to be a Super User!
Thanks for the tip I will check and let u know if it works.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |