Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Forward Forecast (Moving Average) based on Cumulative Count Measure

Hi everyone, I've created a measure that calculates the cumulative count of hires and terminations in order to calculate the headcount (hires minus terminations):   HiredStaff = CALCULATE ( ...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Anonymous 

    Thanks for your reply.

     

    I find the formula it uses involves recursion. However, DAX language doesn't support recursion.

     

     

    Best Regards,

    Community Support Team _Tang

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

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous 

Thanks for your reply.

 

I find the formula it uses involves recursion. However, DAX language doesn't support recursion.

 

 

Best Regards,

Community Support Team _Tang

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

hi v-xiaotang ,

 

does this mean it's impossible to calculate the moving average forecast in Power BI?

 

I get an error message if I try to open your file:

 

Seems my Power BI version is outdated. Unfortunately, I cannot update it myself. I need to wait for my company to do this. Is there a way I can solve this?

 

Best,

Matisse

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous 

    Yes, it's impossible to calculate the value involves recursion with DAX. Besides, you can click Close button, then the file will open.

     

    Best Regards,

    Community Support Team _Tang

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks v-xiaotang !