Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

Need Help

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous

     

    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