VAR Function (DAX)

How does the VAR function (DAX) work?

The VAR function (DAX) stores the result of an expression as a named variable, which can then be passed as an argument to other measure expressions. Once resultant values have been calculated for a variable expression, those values do not change, even if the variable is referenced in another expression.

VAR Formula Syntax

VAR <name> = <expression>

How do you use the VAR function?

The VAR function estimates the variance for a sample of data. Variance provides a general idea of the spread of data. VAR will evaluate logical values, and text representations of numbers hardcoded directly as arguments.

Related Blog Posts

Related Support Forum Posts

What am I doing wrong with VAR?
Sum up occurrencies of selectedvalues of 20 filters
New wins by comparing in 2 different time periods

Considerations when using the VAR function

  • VAR assumes arguments a sample of data, not entire population. If data represents the entire population, use VAR or VAR.P
  • VAR only evaluates numbers in references, ignoring empty cells, text, and logical values like TRUE or FALSE.
  • Arguments can either be numbers or names, arrays, or references that contain numbers.
  • Arguments can be hard-coded values instead of references.
  • To evaluate logical values and/or text in references, use the VARA function.

Related Video Tutorials

Formula examples using the VAR function

=VAR(34.5, 2, 8.9, -4)

=VAR(C5:C10)

=VAR(C2, C3, C4, C5)

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

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