VAR.S Function (DAX)

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 Blog Posts

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.

Related Video Tutorials

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

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formula Reference Guide