NORM.INV
Applies to: Calculated column Calculated table Measure Visual calculation
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
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Example
EVALUATE { NORM.INV(0.908789, 40, 1.5) }
Returns
[Value] |
---|
42.00000200956628780274132 |
Related content
Tilbakemeldinger
https://aka.ms/ContentUserFeedback.
Kommer snart: Gjennom 2024 faser vi ut GitHub Issues som tilbakemeldingsmekanisme for innhold, og erstatter det med et nytt system for tilbakemeldinger. Hvis du vil ha mer informasjon, kan du se:Send inn og vis tilbakemelding for