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? I've tried the below code but I don't know how to do the "greater than" part of the formula:

 

 

Thanks for any help!

 

CM

Need Help

5 Replies

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

    Hi Anonymous ,

     

    You can try to create measures like DAX below.

     

    Period End = LASTDATE('Product'[Date])
 
Period Start= FIRSTDATE( DATESINPERIOD('Product'[Date], [Period End], -3, DAY))
 
Rolling 3 Day Avg = CALCULATE(AVERAGE('Product'[Volume]),DATESBETWEEN ( 'Product'[Date], [Period Start], [Period End] ))

    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

      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.