Forum Discussion
Average and standard deviation
jeremy-b , For Avg of Count/Sum
A measure like
averageX(Values('Date'[Month Year]), calculate(count(Table[Value])) )
This will work for Sub total and GT
Each row year wise Avg
averageX(Values('Date'[Month Year]), calculate(count(Table[Value])) )
This Year = CALCULATE(averageX(Values('Date'[Month Year]), calculate(count(Table[Value])) ),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(averageX(Values('Date'[Month Year]), calculate(count(Table[Value])) ),filter(ALL('Date'),'Date'[Year]=max('Date'[Year]) -1 ))
amitchandak hi,
for my understanding, to use these measures I need to create a date table ?
There are errors in the average calculations, because there may be a month with no value.
For example, I have 11 notifications (January to November) for one year, but there are no notifications in December.
The average is calculated on the 11 values whereas there are 12 months. The last value in December should be counted as 0.