VAR.S DAX Function (Statistical)
Estimates variance based on a sample. Ignores logical values and text in the sample.
Syntax
Parameter | Attributes | Description |
---|---|---|
ColumnName |
A column that contains numeric values corresponding to a sample of a population. |
Return values
A number that represents the variance of a sample population.
Remarks
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] )
Related articles
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
Related functions
Other related functions are:
Last update: Feb 6, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/var-s-function-dax