DAX Statistical Functions

Deriving meaningful insights through statistical functions within Microsoft Power BI.

A. AVERAGE: 

Average Sales = AVERAGE(Sales[Amount]) 

This example calculates the average value of the Amount column in the Sales table, providing the average sales amount. 

B. MEDIAN: 

Median Price = MEDIAN(Products[Price]) 

This example returns the median value from the Price column in the Products table, giving the middle value when the values are arranged in ascending order. 

C. STDEV.P: 

Population Standard Deviation = STDEV.P(Sales[Quantity]) 

This example calculates the population standard deviation of the Quantity column in the Sales table, providing a measure of how dispersed the values are around the mean. 

D. STDEV.S: 

Sample Standard Deviation = STDEV.S(Sales[Revenue]) 

This example calculates the sample standard deviation of the Revenue column in the Sales table, providing an estimate of the population standard deviation based on a sample. 

E. VAR.P: 

Population Variance = VAR.P(Orders[Amount]) 

This example calculates the population variance of the Amount column in the Orders table, measuring the average squared deviation from the mean. 

F. VAR.S: 

Sample Variance = VAR.S(Orders[Quantity]) 

This example calculates the sample variance of the Quantity column in the Orders table, providing an estimate of the population variance based on a sample.