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

The VAR.P function (DAX) returns the variance of the entire population.

## VAR.P Formula Syntax

VAR.P(
<columnName>
)

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

The VAR.P function calculates variance for data that represents an entire population. Variance measures how far a data set is spread out, giving you a general idea of the spread of your data.  The VAR.P function can accept up to 254 arguments

## Related Support Forum Posts

Dax Calculation question
Dax not working
DAX Measure Exception Report

## Considerations when using the VAR.P function

• VAR.P assumes data represents the entire population. If data represents a sample, compute variance with VAR.S.
• VAR.P 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, use the VARPA function.

## Formula examples using the VAR.P function

=VAR.P(InternetSales_USD[SalesAmount_USD])

=VAR.P( B3:B14, D3:D14, F3:F14 )

=VAR.P(A2:A12)

## DOWNLOAD

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