Curbal

Learn how to grow your business with your data and Power BI

You are here: Home / CM Tooltip Glossary Pro+ / STDEV.S

STDEV.S

posted on

« Back to Glossary Index

Syntax

STDEV.S(<ColumnName>)

Tutorial with example

In this series of statistical functions we are looking at the standard deviation:

Download example file:

Download Power BI file: here.

Remarks

  1. STDEV.S assumes that the column refers to a sample of the population. If your data represents the entire population, then compute the standard deviation by using STDEV.P.
  2. STDEV.S uses the following formula:√[∑(x – x̃)²/(n-1)]

    where x̃ is the average value of x for the sample population

    and n is the population size

  3. Blank rows are filtered out from columnName and not considered in the calculations.
  4. An error is returned if columnName contains less than 2 non-blank rows.

This DAX function may return different results when used in a model that is deployed and then queried in DirectQuery mode.

 

Was this helpful?
[Total: 0    Average: 0/5]
See Also:
« Back to Index

Reader Interactions

Let us know your thoughts...