Forum Discussion
Standard Diviation
The simpliest way would be to create a Card visual and place the Score column into the Values box. As long as the Score column is of type number, you'll be able to choose Standard Deviation from the list of aggregations.
Something like this:
Alternatively, you could create a measure using either one of these functions:
https://msdn.microsoft.com/en-us/library/gg492207.aspx
https://msdn.microsoft.com/en-us/library/gg492150.aspx
Anonymous the column of "STANDARD DEVIATION OF WELLNESS SCORE", I use the built in function of power bi which is the simply way you mentioned.,
The column of Score STDEV.P comes from the calculation : Score SD = CALCULATE(STDEV.P(data[Score]),ALLEXCEPT(data, data[Score], data[Name]))
are they supposed to be the same?
Name Score Standard deviation of Wellness Score Score STDEV.P NAME 1 768 0 8 NAME 2 273 0 18 NAME 3 190 0 38 NAME 4 96 0 7 NAME 5 94 0 14 NAME 6 96 0 8 NAME 7 98 0 1 NAME 8 98 0 5 NAME 9 96 0 2 NAME 10 86 0 8 Hi ask,
Based on my test, the build-in standard deviation function should be similar to just using the STDEV.P function without any other filters like below. :smileyhappy:
Score SD = STDEV.P(data[Score])
Regards
v-ljerr-msft have you tried to pick the specific date. for example every wednesday for the past 2 years? How to do that?
