PERCENTILEX.INC() : PERCENTILEX.INC( Orders, Orders[Sales], 0.9 ) : Inclusive percentile across table

STDEVX.P() : STDEVX.P( Sales, Sales[Amount] ) : Population std dev iterator

VARX.P() : VARX.P( Sales, Sales[Amount] ) : Population variance iterator

GEOMEAN() : GEOMEAN( Product[Growth] ) : Geometric mean

RANKX() : RANKX( ALL(Customer), [Total Sales] ) : Dense rank within set

TOPN() : TOPN( 10, Products, [Total Profit] ) : Return top 10 products table

PERCENTILE.INC() : PERCENTILE.INC( Sales, 0.5 ) : Median via inclusive percentile

QUARTILE.INC() : QUARTILE.INC( Sales, 1 ) : Quartile value

MODE.SNGL() : MODE.SNGL( Orders[Ship Mode] ) : Most frequent value

CORR() : CORR( Sales[Amount], Profit[Amount] ) : Correlation coefficient
Previous Next