## 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 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.

## 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 )