# STDEV.P

## Syntax of STDEV.P Function

The syntax of the STDEV.P function is as follows:

STDEV.P(❰ColumnName❱)

``` Where `❰ColumnName❱` is the name of the column containing the values for which you want to calculate the standard deviation. Example Suppose we have a table named "Sales" with two columns: "Region" and "SalesAmount". We want to calculate the standard deviation of the sales amount by region. The DAX formula to do this would be: ```

STDEV.P(Sales[SalesAmount])

``` This will give us the standard deviation of the sales amount in the "Sales" table. Using STDEV.P with Multiple Columns We can also use the STDEV.P function to calculate the standard deviation of multiple columns. For example, suppose we have a table named "Sales" with four columns: "Region", "SalesAmount", "CostAmount", and "ProfitAmount". We want to calculate the standard deviation of all three columns "SalesAmount", "CostAmount", and "ProfitAmount" by region. The DAX formula to do this would be: ```

STDEV.P(Sales[SalesAmount], Sales[CostAmount], Sales[ProfitAmount])

``` This will give us the standard deviation of all three columns in the "Sales" table by region. Using STDEV.P with FILTER Function Another way to use the STDEV.P function is with the FILTER function. The FILTER function allows us to filter the data before calculating the standard deviation. For example, suppose we have a table named "Sales" with two columns: "Region" and "SalesAmount". We want to calculate the standard deviation of the sales amount for the "West" region only. The DAX formula to do this would be: ```

STDEV.P(FILTER(Sales, Sales[Region] = “West”)[SalesAmount])

``` This will give us the standard deviation of the sales amount in the "Sales" table for the "West" region only. The STDEV.P function is a powerful statistical function available in Power BI's DAX language. It allows us to calculate the standard deviation of a given set of values as a sample. We can use it with multiple columns and with the FILTER function to filter the data before calculating the standard deviation. By using the STDEV.P function, we can gain valuable insights into our data and make informed decisions. 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 11-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) ```
``` ```
``` ```
``` ```
``` ```
``` ```