VARX.P
The variance of an expression over a table's rows, taken as the whole population.
Group: Aggregation. Compatible with DAX.
Syntax
VARX.P ( <table>, <expression> )| Parameter | Type | Description |
|---|---|---|
table | Table | The rows to go through. |
expression | Expression evaluated for each row | The number worked out for each row. |
Returns
Number. The variance of the results, taking them as the whole population.
Remarks
- Rows where the expression is blank are left out.
- Over an empty table the result is BLANK; over a single row, 0.
Examples
Eight values
EVALUATE
ROW (
"Population", VARX.P ( DATATABLE ( "Value", INTEGER, { { 2 }, { 4 }, { 4 }, { 4 }, { 5 }, { 5 }, { 7 }, { 9 } } ), [Value] ),
"Sample", VARX.S ( DATATABLE ( "Value", INTEGER, { { 2 }, { 4 }, { 4 }, { 4 }, { 5 }, { 5 }, { 7 }, { 9 } } ), [Value] )
)| Population | Sample |
|---|---|
| 4 | 4.57142857142857 |