Some of these functions in DAX or no longer needed due to advancements in Power BI to summarize data more efficiently. Each function in the table links to an example page where the function is described in more detail with a demo.
If there is a more efficient (less complex, more intuitive) way to get the same result in Power BI it will be noted.
Name of function | Description |
---|---|
AVERAGE(column) | Returns the arithmetic mean for the given column. |
AVERAGEA(column) | Returns the arithmetic mean for the given column. Handles, non-numeric data types. |
AVERAGEX(table,expression) | Calculates the (arithmetic mean) for an expression in the specified table. |
COMBIN(n,k) | Returns the total number of ways k items can be selected from n items given that the order does NOT matter. |
CONFIDENCE.NORM(alpha,standard_dev,size) | Returns the margin of errror for a normal distribution based on your chosen significance level (alpha), known or estimated standard deviation, and sample size. |
CONFIDENCE.T(alpha,standard_dev,size) | Returns the margin of errror for a student's t distribution based on your chosen significance level (alpha), known or estimated standard deviation, and sample size. |
COUNT(column) | Counts the number of rows in a column where only numbers are counted. |
COUNTA(column) | Counts the number of rows in a column that are not empty. |
COUNTAX(column) | Counts the number of rows in a column that are not empty. Use when you want to count specific non-numeric criteria row by row. |
COUNTBLANK(column) | Counts the number of blank rows in the column. |
COUNTBLANK(column) | Counts the number of blank rows in the column. |
COUNTROWS(table) | Counts the number of rows in a table. | COUNTX(column) | Counts the number of rows in a column that are numeric. Use when you want to count specific numeric criteria row by row. |
CROSSJOIN(table,table,[,table]) | Returns a table which contains the product or all rows from all table arguments. Two are more tables are needed. |
DISTINCTCOUNT(column) | Returns the number of distinct rows in the column |
EXPON.DIST(x,lambda,cumulative) | Returns the exponential probability density function, or the cumulative distribution function depending whether the final parameter is true or false. |
GENERATE(table,table) | Returns a table of products between two tables where the current row will not be included. |
GENERATEALL(table,table) | Returns a table of products between two tables where the current row will be included |
GEOMEAN(column) | Returns the geometric mean for the column. |
GEOMEANX(table,expression) | Returns the geometric mean for an expression evaluated over a table. |
MAX(column) | Returns the max value in a numeric column |
MAXA(column) | Returns the max value in a column consisting of number, dates or logical values. |
MAXX(table,expression) | Returns the max value for an expression evaulated over a table. |
MEDIAN(column) | Returns the median value for a column |
MEDIANX(table,expression) | Returns the median value for an expression evaluated over a table. |
PERCENTILE.EXC(column,k) | Returns the kth percentile for a column of numeric values using ${k(n+1)}$ to obtain the rank. |
PERCENTILE.INC(column,k) | Returns the kth percentile for a column of numeric values using ${k(n-1) + 1}$ to obtain the rank. |
PERCENTILEX.EXC(column,k) | Returns the kth percentile for an expression evaluated over each row in a table using ${k(n+1)}$ to obtain the rank. |
PERCENTILEX.INC(column,k) | Returns the kth percentile for an expression evaluated over each for in a table using of numeric values using ${k(n-1) + 1}$ to obtain the rank. |
PERMUT(n,k) | Returns the total number of ways k items can be selected from n items given that the order does matter. |
POISSON.DIST(x,mean,cumulative) | Returns the probability or cummulative probability of x successes occuring for a given mean. |
RANK.EQ(value,column,[order]) | Returns the rank of a specific value from a column. The optional order parameter specifies ascending or descending order. |
RANKX() | Returns the rank of an expression evaluated over a table. |
STDEV.P(column) | Returns the population standard deviation from a column |
STDEV.S(column) | Returns the sample standard deviation from a column |
STDEVX.P | Returns the population standard deviation for an expression evaluated row by row over a table. |
STDEVX.S | Returns the sample standard deviation for an expression evaluated row by row over a table. |