STDEV.P DAX Function (Statistical)
Calculates standard deviation based on the entire population given as arguments. Ignores logical values and text.
Syntax
Parameter | Attributes | Description |
---|---|---|
ColumnName |
A column that contains numbers corresponding to a population. |
Return values
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] )
Related articles
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
Related functions
Other related functions are:
Last update: Jan 23, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/stdev-p-function-dax