## How does the VAR.S function (DAX) work?

The VAR.S function (DAX) returns the variance of a sample population.

## VAR.S Formula Syntax

VAR.S(
<columnName>
)

## How do you use the VAR.S function?

The VAR.S function calculates the variance of a sample of data. Variance provides a general idea of the spread of data.  The VAR.S function can accept up to 254 arguments.

Note while VAR.S ignores text and logicals passed into as cell references, it will evaluate logical values, and text representations of numbers hardcoded directly as arguments. In other words, VAR.S will ignore FALSE when it appears in a range like A1:A10, but will evaluate FALSE when it is provided as an argument.

## Related Support Forum Posts

Dax Calculation question
Dax not working
Nulls/Blanks DAX Measure

## Considerations when using the VAR.S function

• VAR.S assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the variance by using VAR.P.
• Arguments can either be numbers or names, arrays, or references that contain numbers.
• Logical values, and text representations of numbers that you type directly into the list of arguments are counted.
• If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored.
• Arguments that are error values or text that cannot be translated into numbers cause errors.
• If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the VAR.A function.

## Formula examples using the VAR.S function

=VAR.S(InternetSales_USD[SalesAmount_USD])

=VAR.S(A2:A11)

=VAR.S( B3:B1002, D3:D1002, F3:F1002 )

## Related Course Modules 