DAX Statistical - STDEV.P function


Advertisements

Description

Returns the standard deviation of the entire population.

Syntax

STDEV.P (<ColumnName>) 

Parameters

Sr.No. Parameter & Description
1

ColumnName

The name of a column, usually fully qualified.

It cannot be an expression.

Return Value

A real number.

Remarks

DAX STDEV.P function assumes that the column refers to the entire population. If your data represents a sample of the population, then use DAX STDEV.S function.

STDEV.P uses the following formula −

$$\sqrt{\sum\frac{(x\:-\:\bar{x})^{2}}{N}}$$

Where, $\bar{x}$ the average value of $x$ for the entire population, and

N is the population size

Blank rows are filtered out from columnName and not considered in the calculation.

An error is returned if columnName contains less than 2 non-blank rows.

Example

= STDEV.P (Sales[Sales Amount]) 
dax_functions_statistical.htm

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements