Daily DAX : Day 301 NORM.S.INV

NORM.S.INV DAX Function

Description

The NORM.S.INV function in Power BI DAX (Data Analysis Expressions) returns the inverse of the standard normal cumulative distribution for a specified probability. It calculates the z-score (standard normal deviate) corresponding to a given probability in a standard normal distribution (mean = 0, standard deviation = 1).

Syntax

NORM.S.INV(probability)
  • probability: A number between 0 and 1 (exclusive), representing the probability associated with the standard normal distribution.

Return Value

A real number representing the z-score for the given probability.

Use Case

NORM.S.INV is used in statistical analysis to find critical values or thresholds for a standard normal distribution. Common scenarios include:

  • Confidence Intervals: Calculate z-scores for confidence levels (e.g., 95% confidence corresponds to a z-score of approximately 1.96).
  • Hypothesis Testing: Determine critical values for z-tests.
  • Risk Analysis: Model thresholds for probabilities in finance or quality control.

Example

Suppose you want to find the z-score for a 95% probability in a standard normal distribution:

ZScore = NORM.S.INV(0.95)

Result: Approximately 1.645, meaning 95% of the standard normal distribution lies below this z-score.

Notes

  • probability must be between 0 and 1 (exclusive). Otherwise, NORM.S.INV returns an error.
  • Use with other DAX functions to perform advanced statistical calculations in Power BI.

Comments

Post a Comment

Popular posts from this blog

Daily DAX : Day 65 INFO.TABLEPERMISSIONS

 A metadata DAX function that returns a list of all table permissions in the current model with columns matching the schema rowset for table permissions objects Syntax INFO.TABLEPERMISSIONS(<RestrictionName>,<RestrictionValue>) Returns a table with the following fields Field Type ID Integer RoleID Integer TableID Integer FilterExpression String ModifiedTime DateTime State Integer ErrorMessage String MetadataPermission Integer https://dax.guide/info-tablepermissions/
Read more

Daily DAX : Day 55 PV

A financial DAX function that calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), or a future value that’s your investment goal. Syntax PV(<Rate>, <Nr_of_Periods>,<Payments_per_period>,<Future_Value>,<Type>) https://dax.guide/pv/
Read more