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.
