STDEV.P DAX Function (Statistical)

Calculates standard deviation based on the entire population given as arguments. Ignores logical values and text.

Syntax

STDEV.P ( <ColumnName> )

Parameter	Attributes	Description
ColumnName		A column that contains numbers corresponding to a population.

Scalar A single decimal value.

The standard deviation of the entire population.

STDEV.P assumes that the column refers to the entire population.

To compute the standard deviation with a sample of the population, use STDEV.S.

The STDEV.P function internally executes STDEVX.P, without any performance difference.
The following STDEV.P call:

STDEV.P ( table[column] )

corresponds to the following STDEVX.P call:

STDEVX.P (
    table,
    table[column]
)

Learn more about STDEV.P in the following articles:

Statistical Patterns

DAX includes a few statistical aggregation functions, such as average, variance, and standard deviation. Other typical statistical calculations require you to write longer DAX expressions. Excel, from this point of view, has a much richer language. The Statistical Patterns are a collection of common statistical calculations: median, mode, moving average, percentile, and quartile. » Read more

Other related functions are:

Contributors: Alberto Ferrari, Marco Russo