Forum Discussion
Average and standard deviation
jeremy-b , If you need each row consider 12 months you can have measure like
Rolling 12 = CALCULATE(Average(Table[valuet]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))
I do not see any value column, avg of ?
Hi, amitchandak
thank you for your help.
to answer your question, I don't have any values because I need to first count the number of "notifications" per month and then calculate the average of this number.
I need to calculate the average per line (e.g: 2020 and 2021)
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.