Forum Discussion
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 table
Try adding that column after
'Table'[MonthColumn]
3 Replies
Try this:
Average Ovr Months = AVERAGEX(SUMMARIZE('Table','Table'[MonthColumn]), CALCULATE(COUNTROWS('Table')))Thank you, is there a method i could add a thrid metric to this. for example department
Try adding that column after
'Table'[MonthColumn]
