Forward Forecasting Help

[RichardC]

A little help is needed with a formula, any help would very much be appreciated 🙂 . I've been trying for ages and have had to resort to loading in a flat excel file. 

I'm trying to use the previous 3 months as an average to fill in the blanks. % .. I'll explain a little better below.... 

August would use may/june/july numbers... Easy enough. 

September would use the june/july and the recently created august average number.

October would use July/ the calculated august averageand the calculated september average.... 

Can anyone help please 🙂 I;ve attached an example below..

[v-easonf-msft]

Hi, @RichardC 

It is currently difficult to implement recursive averaging in Power BI.

If possible, do something like this in excel, then import data into Power BI.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@RichardC , That needs a recursive approach which is kind of not supported in power bi, You can generate a limited number of forecast

Refer these approches

https://www.thepoweruser.com/2019/07/01/recursive-functions-in-power-bi-power-query/

https://radacad.com/fibonacci-sequence-understanding-the-power-query-recursive-function