referencing forecasted values in DAX

[vpavlov]

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

[v-cherch-msft]

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