NORM.S.DIST

NORM.S.DIST

How to Use the Power BI DAX function NORM.S.DIST

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)

Upcoming Courses

Contact Us

Subject

Your Name (required)

Company/Organisation

Email (required)

Telephone

Training Course(s)

Your Message

Upload Example Document(s) (Zip multiple files)

Copyright, G Com Solutions Ltd, 2024.
Tower Bridge Business Centre, 46-48 East Smithfield, London E1W 1AW
0800 998 9248   |   9:00 a.m. till 5:30 p.m.

Connect With Me: