Ahead Moving Average - Circle Reference?

Question

Hello Guys,&nbsp;I am creating a kind of "Sales Forecast" model. To plan ahead, i am using the 6months average of the Actual Sales ahead. In Excel is quite simple, but how to implement in DAX?To better explaing, i am adding an image with the Actual Sales until September 2017, and how i want calculate the months ahead. Does anyone has any clue?&nbsp;Thank you so much&nbsp;

v-chuncz-msft · Answer

Guipedroso,
&nbsp;
Based on my experience, you may try to invoke a recursive custom function in Query Editor.
https://msdn.microsoft.com/en-us/library/mt185361.aspx

guipedroso · Answer

&nbsp;Hello v-chuncz-msft! thank you so much for your time ...I would like to do it using DAX formulas, because i will use other Dimensions do Categorize the forecast (Products, Customers etc)...&nbsp;

v-chuncz-msft · Answer

Guipedroso,
&nbsp;
As far as I know, there is no elegant way.

guipedroso · Answer

v-chuncz-msft&nbsp;yeah, i tried those "no elegant" ways, but the model is colapsing after the 6 month calculation. Too much "IF"sThats so annoying this situation for circular reference limitation...&nbsp;Cheers

v-chuncz-msft · Answer

Guipedroso,
&nbsp;
It's a mathematical problem of finding the general formula of recurrent sequence.

Forum Discussion

Ahead Moving Average - Circle Reference?

5 Replies

Related content

moving average help

Average and Moving Average

Moving Average

Moving Average

Moving average