Power BI and Azure Data Platform

Statistical DAX patterns

Statistical explained on DAX patterns site

• Average/Mean DAX functions: AVERAGE, AVERAGEA, AVERAGEX
• Moving Average (basic/advanced)
• Variance DAX functions: VAR.S, VAR.P, VARX.S, VARX.P
• Standard Deviation DAX functions: STDEV.S, STDEV.P, STDEVX.S, STDEVX.P
• Median (basic/advanced)
• Mode
• Percentile (basic/advanced)

• Quartiles can be calculated using the Percentile pattern.

• Linear regression
  • Simple linear regression in DAX
  • Multiple Linear Regression in DAX
• Pearson correlation coefficient
  • Pearson correlation coefficient in DAX
  • Calculating Pearson Correlation Coefficient using DAX

Return to:

Top
Back to overview of DAX patterns
Home