VARX.S DAX Function (Statistical)
Estimates variance based on a sample that results from evaluating an expression for each row of a table.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
|
Table Iterator |
The table containing the rows for which the expression will be evaluated. |
|
|
Expression Row Context |
The expression to be evaluated for each row of the table. |
Return values
A number that represents the variance of a sample population.
Remarks
VARX.S assumes that the column refers to a sample of the population.
To compute the variance with the entire population, use VARX.P.
» 3 related functions
Examples
-- Computes the variance over a table of values
--
-- VAR.P : variance over the entire population
-- VAR.S : variance over a sample of the entire population
--
-- VARX is an iterator, VAR is the simplified version in case
-- you are using a single column
DEFINE
TABLE SampleData = { 2, 4, 4, 4, 5, 5, 7, 9 }
EVALUATE
{
( "VAR.P", VAR.P ( SampleData[Value] ) ),
( "VAR.S", VAR.S ( SampleData[Value] ) ),
( "VARX.P", VARX.P ( SampleData, SampleData[Value] ) ),
( "VARX.S", VARX.S ( SampleData, SampleData[Value] ) ),
( "VARX.P", VARX.P ( Sales, Sales[Quantity] * Sales[Net Price] ) ),
( "VARX.S", VARX.S ( Sales, Sales[Quantity] * Sales[Net Price] ) )
}
-- The STDEV.S over SampleData is very different from STDEV.P because the
-- set is small (8 rows for the population, 8 rows for the sample)
-- When applied to Sales, the difference is smaller because
-- the set used has 100,000 rows
| Value1 | Value2 |
|---|---|
| VAR.P | 4.00 |
| VAR.S | 4.57 |
| VARX.P | 4.00 |
| VARX.S | 4.57 |
| VARX.P | 346,327.15 |
| VARX.S | 346,330.61 |
Related articles
Learn more about VARX.S in the following articles:
-
Statistical Patterns
IMPORTANT If you use Power BI, Analysis Services, or Excel 2016 or later versions, you can use the statistical functions in DAX. If you use Excel 2010 or Excel 2013, most of the DAX statistical functions are not available and you can rely on an alternative implementation based on DAX code as described in this page. 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 […] » Read more
Related functions
Other related functions are:
Last update: Feb 2, 2025 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Daniel Otykier
Microsoft documentation: https://docs.microsoft.com/en-us/dax/varx-s-function-dax