DAX Statistical - VAR.P function

Description

Returns the variance of the entire population.

Syntax

VAR.P (<columnName>) 

Parameters

Return Value

A real number.

Remarks

DAX VAR.P function assumes that the column refers to the entire population. If your data represents a sample of the population, then use DAX VAR.S function.

VAR.P uses the following formula −

$${\sum\frac{(x\:-\:\bar{x})^{2}}{N}}$$

Where, $\bar{x}$ the average value of $x$ for the entire population, and

N is the population 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.P (Sales[Sales Amount]) 

Kickstart Your Career

Get certified by completing the course

Get Started