# STDEV.PDAX 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.

## Return values

Scalar A single decimal value.

The standard deviation of the entire population.

## Remarks

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]
)
```
» 1 related article
» 3 related functions

## Examples

```--  Computes the standard deviation over a table of values
--
--  STDEV.P : standard deviation over the entire population
--  STDEV.S : standard deviation over a sample of the entire population
--
--  STDEVX is an iterator, STDEV is the simplified version in case
--  you are using a single column.
DEFINE
TABLE SampleData = { 2, 4, 4, 4, 5, 5, 7, 9 }
EVALUATE
{
( "STDEV.P",  STDEV.P ( SampleData[Value] ) ),
( "STDEV.S",  STDEV.S ( SampleData[Value] ) ),
( "STDEVX.P", STDEVX.P ( SampleData, SampleData[Value] ) ),
( "STDEVX.S", STDEVX.S ( SampleData, SampleData[Value] ) ),
( "STDEVX.P", STDEVX.P ( Sales, Sales[Quantity] * Sales[Net Price] ) ),
( "STDEVX.S", STDEVX.S ( Sales, Sales[Quantity] * Sales[Net Price] ) )
}

-- The STDEV.S over SampleData is very different from STDEV.P because the
-- set is small (8 rows for the population, 8 rows for the sample)
-- When applied to Sales, the difference is small in hidden decimals because
-- the set used has 100,000 rows

```
Value1 Value2
STDEV.P 2.0000000000
STDEV.S 2.1380899353
STDEVX.P 2.0000000000
STDEVX.S 2.1380899353
STDEVX.P 588.4956677430
STDEVX.S 588.4986034618

## Related 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

## Related functions

Other related functions are:

Last update: Sep 28, 2022     » Show contributors

Contributors: Alberto Ferrari, Marco Russo

Microsoft documentation: https://docs.microsoft.com/en-us/dax/stdev-p-function-dax

2018-2022 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us   » Privacy Policy & Cookies

# Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

# Row Context

This expression is executed in a Row Context. Click to read more.

# Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

# Not recommended

The use of this parameter is not recommended.

# Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

# Volatile

A volatile function may return a different result every time you call it, even if you provide the same arguments. Click to read more.

# Deprecated

This parameter is deprecated and its use is not recommended.

# DirectQuery compatibility

Limitations are placed on DAX expressions allowed in measures and calculated columns.
The state below shows the DirectQuery compatibility of the DAX function.

### Contribute

Want to improve the content of STDEV.P? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.