Forecast values directly to new columns?

[Anonymous]

Hi, 

I'm very new to Power BI and testing out its forecasting functionality. Is there a way to export or copy the forecastValues and the confidenceHighBound and confidenceLowBound directly into the initial table that I used to get the values? I'm wondering if the values can directly be added to the table I have. Or do I have to run it through Excel and then upload the new data? I'd like to compare the accuracy of the forecast against actual values and other stuff as well. (The values I'm using currently are just imaginary used for testing purposes)

So basically can I add these data https://imgur.com/a/aLylYtP directly into this table https://imgur.com/a/Q8Worxy

Thanks for the help and answers beforehand!

Aapomage

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

It is not supported to generate forecast values from Analytic to our table directly.  You could reference the videos below to calculate the values manually with DAX. If you haven't learn DAX, it might be a easy way to export data from the Line chart and then get the file into Power BI.

https://www.youtube.com/watch?v=R_hB2hJv04I

https://www.youtube.com/watch?v=U7sl7guoxMI

https://blog.enterprisedna.co/create-dynamic-forward-forecasts-in-power-bi-w-dax/

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.