VAR.P
The variance of a column's numbers, taken as the whole population.
Group: Aggregation. Compatible with DAX.
Syntax
VAR.P ( <columnName> )| Parameter | Type | Description |
|---|---|---|
columnName | Column | A column of numbers. |
Returns
Number. The variance of the column's values, taking them as the whole population.
Remarks
- The mean of the squared differences from the mean: the square of
STDEV.P. - Blanks are left out. With no value, the result is BLANK.
Examples
Variance of the prices per liter
EVALUATE
ROW (
"VAR.P", VAR.P ( Products[Price per liter] ),
"VAR.S", VAR.S ( Products[Price per liter] )
)| VAR.P | VAR.S |
|---|---|
| 170 | 226.666666666667 |