DAX Statistical - VAR.S function
Description
Returns the variance of a sample population.
Syntax
VAR.S (<columnName>)
Parameters
Sr.No. | Parameter & Description |
---|---|
1 |
columnName The name of a column, usually fully qualified. It cannot be an expression. |
Return Value
A real number.
Remarks
DAX VAR.S function assumes that the column refers to a sample of the population. If your data represents the entire population, then use DAX VAR.P function.
VAR.S uses the following formula −
$${\sum\frac{(x\:-\:\bar{x})^{2}}{(n-1)}}$$
Where, $\bar{x}$ the average value of $x$ for the sample population, and
n is the sample size
Blank rows are filtered out from columnName and not considered in the calculation.
An error is returned if columnName contains less than 2 non-blank rows.
Example
= VAR.S (West_Sales[Amount])