Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Rolling 12 Month Counts

I need to calculate rolling average in a little different way: Step1 Get the active employee counts 12 month back i.e; 6/1/2019 counts as of today  Step 2 Get active employee counts previous month ...
Need Help
Show and Tell
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    "Step1 Get the active employee counts 12 month back", did you mean the duration is  2018/6/1-2019/6/1? If so , you could try to refer to my sample for details.

    Best Regards,
    Zoe Zhi

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

     

dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous , 

"Step1 Get the active employee counts 12 month back", did you mean the duration is  2018/6/1-2019/6/1? If so , you could try to refer to my sample for details.

Best Regards,
Zoe Zhi

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