NORM.INV Function (DAX)

How does the NORM.INV function (DAX) work?

The NORM.INV function (DAX) returns the X value from a normal distribution, given a cumulative probability.

NORM.INV Formula Syntax

NORM.INV(
     Probability, Mean, Standard_dev
)

How do you use the NORM.INV function?

This function will calculate the inverse of the normal cumulative distribution for a supplied value of x, with a given distribution mean and standard deviation. The function will calculate the probability to the left of any particular point in a normal distribution.

Related Blog Posts

Related Support Forum Posts

Dax Calculation question
Dax not working
DAX Buffer Calculation Query

Considerations when using the NORM.INV function

The NORM.INV formula uses the following arguments:

  1. Probability (required argument) – This is the probability corresponding to normal distribution. It is the value at which we want to evaluate the inverse function.
  2. Mean (required argument) – This is the arithmetic mean of the distribution.
  3. Standard_dev (required argument) – This is the standard deviation of the distribution.

Related Video Tutorials

Formula examples using the NORM.INV function

EVALUATE { NORM.INV(0.908789, 40, 1.5) }

=NORM.INV(A2,A3,A4)

=NORM.INV( 0.6, 5, 2 )

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formula Reference Guide