Calculates variance based on the entire population. Ignores logical values and text in the population.
A column that contains values corresponding to a population.
A number with the variance of the entire population.
VAR.P assumes that the column refers to the entire population.
To compute the variance with a sample of the population, use VAR.S.
The VAR.P function internally executes VARX.P, without any performance difference.
The following VAR.P call:
VAR.P ( table[column] )
corresponds to the following VARX.P call:
VARX.P ( table, table[column] )
Learn more about VAR.P in the following articles:
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
MSDN documentation: https://docs.microsoft.com/en-us/dax/var-p-function-dax