Summary of DAX Statistical Functions

Statistical functions are essential for calculating values related to probability and statistical distributions, such as standard deviation and permutations. These functions aid in data analysis, helping users draw insights from statistical measures.

Key Points:

• Distribution Functions:

  • BETA.DIST / BETA.INV: For beta distribution and its inverse.

  • CHISQ.DIST / CHISQ.INV: For chi-squared distribution and its inverse.

  • NORM.DIST / NORM.INV: For normal distribution and its inverse.

  • POISSON.DIST / EXPON.DIST: For Poisson and exponential distributions.

  • T.DIST / T.INV: For Student's t-distribution and its inverse.

• Central Tendency and Variation:

  • MEDIAN / MEDIANX: Calculate the median value.

  • GEOMEAN / GEOMEANX: Calculate the geometric mean.

  • STDEV.P / STDEV.S / VAR.P / VAR.S: Return the standard deviation and variance of entire and sample populations.

• Percentiles and Rankings:

  • PERCENTILE.EXC / PERCENTILE.INC: Find percentiles within a range.

  • RANK.EQ / RANKX: Rank numbers within a list or table.

• Combinatorial Functions:

  • COMBIN / COMBINA: Calculate combinations.

  • PERMUT: Calculate permutations.

• Confidence Intervals:

  • CONFIDENCE.NORM / CONFIDENCE.T: Return confidence intervals using normal and Student's t distributions.

These functions are vital for robust statistical analysis, enabling in-depth data examination, performance tracking, and decision-making processes.