VAR.S DAX Function (Statistical)

Estimates variance based on a sample. Ignores logical values and text in the sample.

Syntax

VAR.S ( <ColumnName> )

Parameter	Attributes	Description
ColumnName		A column that contains numeric values corresponding to a sample of a population.

Scalar A single decimal value.

A number that represents the variance of a sample population.

VAR.S assumes that the column refers to a sample of the population.

To compute the variance with the entire population, use VAR.P.

The VAR.S function internally executes VARX.S, without any performance difference.
The following VAR.S call:

VAR.S ( table[column] )

corresponds to the following VARX.S call:

VARX.S (
    table,
    table[column]
)

Learn more about VAR.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