**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:

**Probability**(required argument) – This is the probability corresponding to normal distribution. It is the value at which we want to evaluate the inverse function.**Mean**(required argument) – This is the arithmetic mean of the distribution.**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 )