Forum Discussion

NewbieJono's avatar
NewbieJono
Icon for Post Partisan rankPost Partisan
3 years ago
Solved

Average over months

Hello all, i have used the average trend line to work out the average for this visuaul.   what wold the dax be to work out average myself? the counts in this charts are based on count rows in a t...
Need Help
  • ray_aramburo's avatar
    ray_aramburo
    3 years ago

    Try adding that column after 

    'Table'[MonthColumn]
ray_aramburo's avatar
ray_aramburo
Icon for Super User rankSuper User
3 years ago

Try this:

Average Ovr Months = AVERAGEX(SUMMARIZE('Table','Table'[MonthColumn]), CALCULATE(COUNTROWS('Table')))