Caculate the data from time series forecasting in power view

[erche3]

Hello All

I am using the time series forecasting function from the power view , and generating statistics forecast . ( below picture showing as an example)

I am just wondering how I could use the outcome data from the prediction and compare with last year's outcome 

e.g 

if I want to  Sum( YTD sales in 2020 + prediction in the rest of periods ) /  sales 2019 

how could I caculate the sales from prediction ?

thanks very much !

 

[v-yuta-msft]

@erche3 ,

Not sure what's the logic in your forecast expression, could you clarify about it and share some sample data?

Regards,

Jimmy Tao

[erche3]

thanks for reply Jimmy 

forecast is generated from the line chart with the function in the Analytics (please see attached picture )

how could I caculate them ? 

 

[v-yuta-msft · Accepted solution]

@erche3 ,

Currently the feature is only available for line chart, the forecast feature should mixed some statistic algorithm like linear regression algorithm.

Community Support Team _ Jimmy Tao

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