Forum Discussion

EStieg's avatar
EStieg
Microsoft Employee
6 years ago
Solved

FAQ: Ask Amanda Anything Questions & Answers

If you were among the many attendees of the recent Ask Amanda Anything sneak peek, you know there were terrific questions being asked!  We've captured those questions and responses from the team and ...
Tips and Tricks
iamriz's avatar
iamriz
Helper II
6 years ago

Hi Amanda,

 

Is it possible now to do Forecasting using ARIMA model in DAX for Power BI Desktop? So far I am directed to using R script from this thread: https://community.powerbi.com/t5/Desktop/quot-Forecasting-with-ARIMA-quot-in-Table-Visual/td-p/88666....

 

What I want to do is as follows:

1. Show 60 days worth of data in a bar graph.

2. In the same graph as #1, draw a line for the moving average for 10 days of actual data.

3. Forecast the future next 10 days using the 60 days data and using ARIMA model, then show the results as extension to the line drawn in #2.

 

Currently, I am already able to achieve #1 and #2 above using DAX and "Line and clustered column chart" Visual. I already was able to get the forecast values using R script. My problem is I cannot transform the resulting data from R and load it as Modelling Data in Power BI so I can use the results in Dax. If I won't be able to do #3 via DAX, then I have to proceed doing everything in R script. That's where I am currently.

 

Any advice or feedback will be much appreciated.