Skip to content

Latest commit

 

History

History
50 lines (33 loc) · 1.2 KB

norm-inv-function-dax.md

File metadata and controls

50 lines (33 loc) · 1.2 KB
description title
Learn more about: NORM.INV
NORM.INV function (DAX) | Microsoft Docs

NORM.INV

[!INCLUDEapplies-to-measures-columns-tables-visual-calculations]

The inverse of the normal cumulative distribution for the specified mean and standard deviation.

Syntax

NORM.INV(Probability, Mean, Standard_dev)

Parameters

Term Definition
Probability A probability corresponding to the normal distribution.
Mean The arithmetic mean of the distribution.
Standard_dev The standard deviation of the distribution.

Return value

Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

Remarks

[!INCLUDE function-not-supported-in-directquery-mode]

Example

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

Returns

[Value]
42.00000200956628780274132

Related content

NORM.S.INV
NORM.S.DIST function
NORM.DIST function