Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
The inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORM.INV(Probability, Mean, Standard_dev)
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. |
Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
EVALUATE { NORM.INV(0.908789, 40, 1.5) }
Returns
[Value] |
---|
42.00000200956628780274132 |
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today