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.

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.