Forum Discussion

Almantas32's avatar
Almantas32
Helper II
5 years ago
Solved

Monthly rolling average

Hey guys,    I wanted to calculate the monthly rolling average of completed tasks, using the same formula I used for weekly average. But something is off and it does not work for moths in the same ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Almantas32 ,

    Try like

    Tasks Monthly Average = CALCULATE(AVERAGEX(VALUES('Calendar Tasks'[Month Name]), [Total Tasks Done]),FILTER(ALLSELECTED('Calendar Tasks'), 'Calendar Tasks'[Month Name] <= MAX('Calendar Tasks'[Month Name])))

     

    Some changes will be need in case you get additional data

  • Almantas32's avatar
    Almantas32
    Helper II
    5 years ago

    Hey, 

     

    the problem is the rolling average (yellow line) in upper chart should show a rolling average all months + current. Instead it shows the sum off tasks that month. 

    I use the same formula for weeks in the chart below and it works. 

     

     

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      Almantas32 ,

      Try like

      Tasks Monthly Average = CALCULATE(AVERAGEX(VALUES('Calendar Tasks'[Month Name]), [Total Tasks Done]),FILTER(ALLSELECTED('Calendar Tasks'), 'Calendar Tasks'[Month Name] <= MAX('Calendar Tasks'[Month Name])))

       

      Some changes will be need in case you get additional data