Statistical Functions (DAX)

 

Data Analysis Expressions (DAX) provides many functions for creating aggregations such as sums, counts, and averages. These functions are very similar to aggregation functions used by Microsoft Excel. This section lists the statistical and aggregation functions provided in DAX.

ADDCOLUMNS Function (DAX)

AVERAGE Function (DAX)

AVERAGEA Function (DAX)

AVERAGEX Function (DAX)

BETA.DIST Function (DAX)

BETA.INV Function (DAX)

CHISQ.INV Function (DAX)

CHISQ.INV.RT Function (DAX)

CONFIDENCE.NORM Function (DAX)

CONFIDENCE.T Function (DAX)

COUNT Function (DAX)

COUNTA Function (DAX)

COUNTAX Function (DAX)

COUNTBLANK Function (DAX)

COUNTROWS Function (DAX)

COUNTX Function (DAX)

CROSSJOIN Function (DAX)

DATATABLE Function

DISTINCTCOUNT Function (DAX)

EXPON.DIST Function (DAX)

GENERATE Function (DAX)

GENERATEALL Function (DAX)

GEOMEAN Function (DAX)

GEOMEANX Function (DAX)

MAX Function (DAX)

MAXA Function (DAX)

MAXX Function (DAX)

MEDIAN Function (DAX)

MEDIANX Function (DAX)

MIN Function (DAX)

MINA Function (DAX)

MINX Function (DAX)

PERCENTILE.EXC Function (DAX)

PERCENTILE.INC Function (DAX)

PERCENTILEX.EXC Function (DAX)

PERCENTILEX.INC Function (DAX)

POISSON.DIST Function (DAX)

RANK.EQ Function (DAX)

RANKX Function (DAX)

ROW Function (DAX)

SAMPLE Function (DAX)

SELECTCOLUMNS Function (DAX)

SIN Function (DAX)

SINH Function (DAX)

STDEV.P Function (DAX)

STDEV.S Function (DAX)

STDEVX.P Function (DAX)

STDEVX.S Function (DAX)

SQRTPI Function (DAX)

SUMMARIZE Function (DAX)

TAN Function (DAX)

TANH Function (DAX)

TOPN Function (DAX)

VAR.P Function (DAX)

VAR.S Function (DAX)

VARX.P Function (DAX)

VARX.S Function (DAX)

XIRR Function (DAX)

XNPV Function (DAX)

DAX Function Reference

Community Additions

Show: