# NORM.S.DIST

## Y ## Syntax

The syntax for the NORM.S.DIST function is as follows:

NORM.S.DIST(x, cumulative)

``` Where: - `x` is the value for which you want to calculate the standard normal cumulative distribution function. - `cumulative` is a boolean value that determines the form of the distribution to be used. If `cumulative` is `TRUE` or omitted, NORM.S.DIST returns the cumulative distribution function. If `cumulative` is `FALSE`, NORM.S.DIST returns the probability density function. Examples Let's look at some examples of how to use the NORM.S.DIST function in Power BI. Example 1: Calculate the standard normal cumulative distribution function Suppose you have a dataset with a column named `Data` that contains a set of values. You want to calculate the standard normal cumulative distribution function for each value in the column. To do this, you can use the following DAX formula: ```

=CALCULATE(NORM.S.DIST(Data, TRUE))

``` This formula will calculate the standard normal cumulative distribution function for each value in the `Data` column. Example 2: Calculate the probability density function Suppose you want to calculate the probability density function for a specific value in your dataset. To do this, you can use the following DAX formula: ```

=NORM.S.DIST(Data, FALSE)

``` This formula will calculate the probability density function for the value in the `Data` column. The NORM.S.DIST function is a powerful tool for calculating the standard normal cumulative distribution function and probability density function in Power BI. By understanding the syntax and examples provided in this article, you should be able to effectively use this function in your own datasets. 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 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) ```
``` ```
``` ```
``` ```
``` ```
``` ```