StdevP

How to Use the Power Fx StdevPĀ  Function in Power Apps

What is the Power Fx StdevP Function?

The Power Fx StdevP function is a statistical function that calculates the standard deviation of a population based on a set of values. The standard deviation measures the amount of variation or dispersion of a data set. This function takes a set of values as its input and returns the standard deviation of the population.

How to Use the Power Fx StdevP Function in Power Apps

To use the Power Fx StdevP function in Power Apps, follow these steps:

1. Open Power Apps and create a new app or open an existing one.

2. Create a control, such as a textbox or label, where you want to display the standard deviation.

3. Click on the control to select it and go to the “Advanced” section in the “Properties” pane.

4. In the “Advanced” section, click on the “Fx” button to open the formula bar.

5. Type the following formula in the formula bar:


StdevP(DataSource, ColumnName)


Replace "DataSource" with the name of the data source that contains the values you want to calculate the standard deviation for. Replace "ColumnName" with the name of the column that contains the values.

For example, if you have a table named "Sales" with a column named "Revenue", the formula would be:


StdevP(Sales, Revenue)


6. Press "Enter" to calculate the standard deviation and display the result in the control.

Additional Options

There are a few additional options you can use with the Power Fx StdevP function:

- You can use the "ClearCollect" function to create a collection of the values you want to calculate the standard deviation for, and then use the collection as the data source in the StdevP function. For example:


ClearCollect(MyCollection, Sales)

StdevP(MyCollection, Revenue)


- You can use the "Filter" function to calculate the standard deviation for a subset of the data. For example, if you only want to calculate the standard deviation for sales in a specific region, you can use the following formula:


StdevP(Filter(Sales, Region = “North”), Revenue)


- You can use the "GroupBy" function to calculate the standard deviation for groups of data. For example, if you want to calculate the standard deviation for sales by region, you can use the following formula:


StdevP(GroupBy(Sales, “Region”, “SalesByRegion”), SalesByRegion.Revenue)


The Power Fx StdevP function is a useful tool for calculating the standard deviation of a population based on a set of values in Power Apps. By following the steps outlined in this article, you can easily use this function in your own apps. With the additional options available, you can customize the function to suit your specific needs.

Power Apps Training Courses by G Com Solutions (0800 998 9248)