# STDEV.S

## What is the STDEV.S function?

The STDEV.S function is a DAX function that calculates the standard deviation of a set of numbers. It is used to measure the amount of variation or dispersion in a set of data. The STDEV.S function assumes that the data represents a sample of a larger population.

## How to use the STDEV.S function

The syntax for the STDEV.S function is as follows:

STDEV.S(❰number1❱, [❰number2❱], …)

``` Where `❰number1❱` is the first number or column that you want to calculate the standard deviation for, and `❰number2❱` (optional) is the second number or column, and so on. You can also use the STDEV.S function with a table column. Here is an example of how to use the STDEV.S function with a table column: ```

STDEV.S(Table[Column])

``` Where `Table` is the name of the table, and `Column` is the name of the column. Example usage of the STDEV.S function Let's say you have a table of sales data for a company, and you want to calculate the standard deviation of the sales for each product category. You can use the STDEV.S function for this. Here is an example of how to use the STDEV.S function with a table column: ```

STDEV.S(Sales[Amount])

``` Where `Sales` is the name of the table, and `Amount` is the name of the column that contains the sales data. If you want to calculate the standard deviation of the sales for each product category, you can use the following formula: ```

STDEV.SX.S(

FILTER(Sales, Sales[Category] = “Product1”),

Sales[Amount]

)

``` Where `Sales` is the name of the table, `Category` is the name of the column that contains the product categories, and `"Product1"` is the category that you want to calculate the standard deviation for. The STDEV.S function is a powerful tool that you can use to calculate the standard deviation of a set of data in Power BI. By using this function, you can measure the amount of variation or dispersion in your data, and gain insights into the underlying trends and patterns. We hope this article has been helpful in explaining what the STDEV.S function is, how to use it, and provided some examples. Power BI DAX Training Courses by G Com Solutions (0800 998 9248) Power BI DAX Intensive Training Course £1,050.00 – £26,550.00 Select optionsContinue Loading Done Power BI DAX Introduction £395.00 – £9,750.00 Select optionsContinue Loading Done Power BI DAX Intermediate £395.00 – £9,750.00 Select optionsContinue Loading Done Power BI DAX Advanced £395.00 – £9,750.00 Select optionsContinue Loading Done Upcoming Courses 16-18 September 202411-13 November 2024 Contact Us Subject Your Name (required) Company/Organisation Email (required) Telephone Training Course(s) Power BI Intensive TrainingPower BI introduction Power BI IntermediatePower BI AdvancedDAXPower Query MPower BI CertificationPower BI AdministrationPower PlatformPower AutomatePower AppsOTHER Your Message Upload Example Document(s) (Zip multiple files) ```
``` ```
``` ```
``` ```
``` ```
``` ```