Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Cumulative average without using "datesinperiod" function

Hi,   I'm trying to understand filter context and one of my challenges is to write a rolling average formula without using "datesinperiod". Please can you tell me how write a 3 day rolling average?...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Is it impossible to do without the "datesinperiod" function? Please can you tell me why?

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Does the formulas above make sense? Could you please tell me the reason why you don't want to use DATESINPERIOD function?

 

Best Regards,

Amy

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-xicai ,

     

    It makes sense but I don't feel comfortable that I am unable to do the calculation without the "datesinperiod" function. I don't feel comfortable just blindly using built in filters, hope that makes sense? (happy to use built in functions later on when I know what I'm doing to tidy up the code)

     

    CM

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

     hi v-xicai

    I would like to know an alternative for DATESINPERIOD since my data is not at day level and I dont have a date table.

    Could you help please?