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

STDEVX.S ( <Table>, <Expression> )

Parameter	Attributes	Description
Table Iterator		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.

Scalar A single decimal value.

The standard deviation of a sample population.

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.

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

Other related functions are:

Contributors: Alberto Ferrari, Marco Russo