Downloads

DAX functions

Measures and calculated tables for Power BI, Excel Power Pivot and Analysis Services. 174 functions, grouped by what you use them for.

Aggregation

Date and time

Filter and context

ALLReturns every row or every value of a table or column, ignoring the filters on it.ALLEXCEPTRemoves every filter on a table except the filters on the columns you list.ALLNOBLANKROWReturns all the rows of a table except the blank row that a broken relationship can add.ALLSELECTEDReturns the rows or values that remain after slicers and page filters, ignoring the visual's own row and column grouping.CALCULATEEvaluates an expression in a filter context that you change.CALCULATETABLEEvaluates a table expression in a filter context that you change.DISTINCTReturns the unique values of a column, or the table with duplicate rows removed.EARLIERReturns the value of a column from an outer row, while a formula loops over an inner row.EARLIESTReturns the value of a column from the outermost row context, the row where the nesting started.FILTERReturns the rows of a table where a condition is true, checked one row at a time.HASONEFILTERReturns TRUE when exactly one filter is applied directly to a column, whatever the number of values in that filter.ISEMPTYReturns TRUE when a table has no rows in the current filter context.KEEPFILTERSCombines a new filter with the existing filter, so only rows that satisfy both are kept.REMOVEFILTERSClears the filters on the tables or columns you name, or on the whole model when used with no arguments. Works only as a CALCULATE filter.VALUESReturns the distinct values, or the distinct rows, that are visible in the current filter context.VARStores a value or a table in a named variable that the RETURN part can reuse.

Financial

Information

Logical

Math

Ranking and windows

Relationships and lookup

Table construction

Text

Time intelligence: balances

Time intelligence: first and last

Time intelligence: shift and compare

Time intelligence: to date