Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

5 Year Rolling Average DAX

Hi Experts

 

How could i modify the following DAX Measure to work out the year rolling average..

 

Need Help
  • Seanan's avatar
    Seanan
    3 years ago

    Hi Anonymous,

     

    Could you please try this:

    5 Year Rolling Avg = AVERAGEX(DATESINPERIOD('Dates'[Date],LASTDATE('Dates'[Date]),-5,YEAR),[Total Sales])

     

1 Reply

  • Seanan's avatar
    Seanan
    Icon for Solution Supplier rankSolution Supplier
    3 years ago

    Hi Anonymous,

     

    Could you please try this:

    5 Year Rolling Avg = AVERAGEX(DATESINPERIOD('Dates'[Date],LASTDATE('Dates'[Date]),-5,YEAR),[Total Sales])