STDEV.S

STDEV.S

posted on September 22, 2018

« Back to Glossary Index

Syntax

STDEV.S(<ColumnName>)

Tutorial with example

In this series of statistical functions we are looking at the standard deviation:

DAX Fridays! #97: STANDARD DEVIATION EXPLAINED | Who is the best player, LeBron or Durant?

Download example file:

Download Power BI file: here.

Remarks

STDEV.S assumes that the column refers to a sample of the population. If your data represents the entire population, then compute the standard deviation by using STDEV.P.
STDEV.S uses the following formula:√[∑(x – x̃)²/(n-1)]
where x̃ is the average value of x for the sample population

and n is the population size
Blank rows are filtered out from columnName and not considered in the calculations.
An error is returned if columnName contains less than 2 non-blank rows.

This DAX function may return different results when used in a model that is deployed and then queried in DirectQuery mode.