Forum Discussion

Guipedroso's avatar
Guipedroso
Frequent Visitor
9 years ago

Ahead Moving Average - Circle Reference?

Hello Guys,   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 bet...
Guipedroso's avatar
Guipedroso
Frequent Visitor
9 years ago

 

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)...

 

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Guipedroso,

     

    As far as I know, there is no elegant way.

    • Guipedroso's avatar
      Guipedroso
      Frequent Visitor
      9 years ago

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

       

      Cheers

      • v-chuncz-msft's avatar
        v-chuncz-msft
        Icon for Community Support rankCommunity Support
        9 years ago

        Guipedroso,

         

        It's a mathematical problem of finding the general formula of recurrent sequence.