STDEVX.S DAX Function (Statistical)
Estimates standard deviation based on a sample that results from evaluating an expression for each row of a table.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Table |
The table containing the rows for which the expression will be evaluated. |
|
|
Expression Row Context |
The expression to be evaluated for each row of the table. |
Return values
The standard deviation of a sample population.
Remarks
STDEVX.S assumes that the column refers to a sample of the population.
To compute the standard deviation with the entire population, use STDEVX.P.
Related articles
Learn more about STDEVX.S 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: Oct 13, 2018 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/stdevx-s-function-dax