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
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(C2, C3, C4, C5)
Related Course Modules
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.