How to calculate the resultant figures from the forecast feature of the line graph visual?

[AAbell]

Hi All,

I'm trying to produce a measure for a dashboard that shows the expectant EOY cumulative sales result based on a straight line projection. (preferably with a variance figure)

I am able to get this via calculations? I'm pretty new to DAX/Power BI.

[v-yulgu-msft]

Hi @AAbell,

"Want to put the expectant EOY trend here"

Do you want to split the trend line from the chart to display it in a separate section? If so, it is not available to achieve.

"Is there a way to calculate the forecast figures (from the analytics pane) in a table "

No. As if now, forecasting feature is only supported in chart visual.

Best regards,

Yuliana Gu