DAX Statistical - STDEV.S function

Description

Returns the standard deviation of a sample population.

Syntax

STDEV.S (<ColumnName>)

Parameters

Return Value

A real number.

Remarks

DAX STDEV.S function assumes that the column refers to a sample of the population. If your data represents the entire population, then use DAX STDEV.P function.

STDEV.S uses the following formula −

$$\sqrt{\sum\frac{(x\:-\:\bar{x})^{2}}{(n-1)}}$$

Where, $\bar{x}$ the average value of $x$ for the entire population, and

n is the sample size

Blank rows are filtered out from columnName and not considered in the calculation.

An error is returned if columnName contains less than 2 non-blank rows.

Example

= STDEV.S (West_Sales[Amount]) 

Kickstart Your Career

Get certified by completing the course

Get Started