Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX calculation for Rolling Data

Please let me know if more information is needed.

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , seem like Avergae of Last 12 months

     

    exp

    12 Month Avg = CALCULATE(AverageX(Values('Date'[MONTH Year]),calculate(Sum('Table'[Value)))
    ,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))

     

    if needed multiply by 2

    12 Month Avg = CALCULATE(AverageX(Values('Date'[MONTH Year]),calculate(Sum('Table'[Value)))
    ,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))*2