cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vpavlov Visitor
Visitor

referencing forecasted values in DAX

Hi,

 

I created a chart showing my data and created a forecast (using the built-in tool on the Analytics pane). The forecast nicely shows on the chart and choosing "Show data" (from the right-click menu on the chart) takes me to the forecast data (columns "forecastValue", "confidenceHighBound" and "confidenceLow Bound").

 

Is there a way to reference in the DAX the forecast values (column "forecastValue")? If not, is there a way to export them programmatically (I know how to do that manually but this is not practical) to a CSV file? Sorry if I am overlooking something obvious.

 

Thank you.

Valery

1 REPLY 1
Community Support Team
Community Support Team

Re: referencing forecasted values in DAX

Hi @vpavlov

 

It seems there's no better way to achive that. You may manually export it to a CSV file and create a query to import the values in the csv file.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.