⚡

DAX Functions Reference

Function	Category	Description	Microsoft Docs	Status	Syntax
LINEST	New Functions	Uses the least squares method to calculate a straight line that best fits the given data, then returns a table describing that line	1265	Completed	LINEST(<known_y_values>, <known_x_values>[, <const>])
LINESTX	New Functions	Uses the least squares method to calculate a straight line that best fits the given data, then returns a table describing that line	1266	Completed	LINESTX(<table>, <known_y_expression>, <known_x_expression>[, <const>])
RANK	New Functions	Returns the ranking of the current row within the specified context	1263	Completed	RANK([<ties>], <expression>[, <expression>]..., [<orderBy>], [<blanks>], [<partitionBy>], [<matchBy>], [<reset>])
ROWNUMBER	New Functions	Returns the unique ranking for the current context within the specified partition sorted by the specified order	1264	Completed	ROWNUMBER([<orderBy>], [<partitionBy>], [<matchBy>], [<reset>])
MATCHBY	New Functions	Defines the columns that determine how to match data and identify the current row	1262	Completed	MATCHBY(<column>[, <column>]...)
NEXT	New Functions	Returns the next value in the current context for the specified column	1260	Completed	NEXT(<column>[, <steps>])
LAST	New Functions	Returns the last value in the current context for the specified column	1259	Completed	LAST(<column>)
PREVIOUS	New Functions	Returns the previous value in the current context for the specified column	1261	Completed	PREVIOUS(<column>[, <steps>])
FIRST	New Functions	Returns the first value in the current context for the specified column	1258	Completed	FIRST(<column>)
LOOKUPWITHTOTALS	New Functions	Retrieves values from a table, including total rows	1257	Completed	LOOKUPWITHTOTALS(<result_columnName>, <search_columnName>, <search_value>[, <alternate_result>])
LOOKUP	New Functions	Retrieves values from a table	1256	Completed	LOOKUP(<result_columnName>, <search_columnName>, <search_value>[, <alternate_result>])
EXTERNALMEASURE	Other	Transfers an external measure from the external tool where it is defined into the DAX code of a calculated column or measure	1253	Completed	EXTERNALMEASURE(<MeasureName>)
TOCSV	Other	Returns a table as a string in CSV format	1254	Completed	TOCSV(<table> [, <maxRows> [, <delimiter> [, <includeHeaders>]]])
EVALUATEANDLOG	Other	Returns the value of the expression and logs it to a DAX query plan	1252	Completed	EVALUATEANDLOG(<expression>)
TOJSON	Other	Returns a table as a string in JSON format	1255	Completed	TOJSON(<table> [, <maxRows>])
USERELATIONSHIP	Relationship	Specifies the relationship to be used in a specific calculation as the one that exists between columnName1 and columnName2	1248	Completed	USERELATIONSHIP(<columnName1>,<columnName2>)
CROSSFILTER	Relationship	Specifies the cross-filtering direction to be used in a calculation for a relationship that exists between two columns	1249	Completed	CROSSFILTER(<columnName1>, <columnName2>, <direction>)
BLANK	Other	Returns a blank value	1250	Completed	BLANK()
RELATEDTABLE	Relationship	Evaluates a table expression in a context modified by the given filters	1247	Completed	RELATEDTABLE(<tableName>)
ERROR	Other	Raises an error with the text specified in ErrorText	1251	Completed	ERROR(<ErrorText>)
ROLLUPISSUBTOTAL	Table Manipulation	Pairs up the rollup groups with the column added by ROLLUPADDISSUBTOTAL within an ADDCOLUMNS expression	1244	Completed	ROLLUPISSUBTOTAL ( [<grandTotalFilter>], <expr> )
ROLLUPADDISSUBTOTAL	Table Manipulation	Pairs up the rollup groups with the column added by ROLLUPADDISSUBTOTAL within an ADDCOLUMNS expression	1243	Completed	ROLLUPADDISSUBTOTAL ( [<grandTotalFilter>], <expr> )
ROLLUPGROUP	Table Manipulation	Identifies a subset of columns specified in the call to SUMMARIZE or SUMMARIZECOLUMNS that should be used to calculate groups of subtotals	1242	Completed	ROLLUPGROUP(<groupBy_columnName> [, <groupBy_columnName> [, ... ] ] [, <isGrandTotalColumn>] )
RELATED	Relationship	Returns a related value from another table	1246	Completed	RELATED(<column>)
IGNORE	Table Manipulation	Modifies the behavior of the SUMMARIZECOLUMNS function by omitting specific expressions from the BLANK/NULL evaluation	1245	Completed	IGNORE(<expression>)
SUMMARIZE	Table Manipulation	Returns a summary table for the requested totals over a set of groups	1238	Completed	SUMMARIZE(<table>, [<groupBy_columnName> [, [<filterTable>] [, <groupBy_columnName> [, [<filterTable>] [, ... ] ] ] ] ], [<name>, <expression> [, <name>, <expression> [, ... ] ] ])
CURRENTGROUP	Table Manipulation	Returns a set of rows from the "table" parameter of a GROUPBY function that belong to the current row context	1240	Completed	CURRENTGROUP()
SUMMARIZECOLUMNS	Table Manipulation	Returns a summary table over a set of groups	1239	Completed	SUMMARIZECOLUMNS( [<groupBy_columnName> [, [<filterTable>] [, <groupBy_columnName> [, [<filterTable>] [, ... ] ] ] ] ], [<filterExpression>], [<name>, <expression> [, <name>, <expression> [, ... ] ] ] )
GROUPBY	Table Manipulation	Groups the rows of a table by the values in specified columns and aggregates the data in other columns	1237	Completed	GROUPBY(<table>, [<groupBy_columnName> [, [<filterTable>] [, <groupBy_columnName> [, [<filterTable>] [, ... ] ] ] ] ], [<name>, <expression> [, <name>, <expression> [, ... ] ] ])
ROLLUP	Table Manipulation	Identifies a subset of columns specified in the call to SUMMARIZE function that should be used to calculate subtotals	1241	Completed	ROLLUP(<groupBy_columnName> [, <groupBy_columnName> [, ... ] ] )
ADDMISSINGITEMS	Table Manipulation	Returns a table with missing combinations of values from the specified columns	1235	Completed	ADDMISSINGITEMS( [<showAll_columnName> [, <showAll_columnName> [, ... ] ] ], <table_expression> [, <groupBy_columnName> [, [<filterTable>] [, <groupBy_columnName> [, [<filterTable>] [, ... ] ] ] ] ] )
DISTINCT	Table Manipulation	Returns a one-column table that contains the distinct values from the specified column	1233	Completed	DISTINCT(<column>)
GENERATESERIES	Table Manipulation	Returns a single column table containing the values of an arithmetic series	1234	Completed	GENERATESERIES(<startValue>, <endValue>[, <incrementValue>])
DETAILROWS	Table Manipulation	Evaluates a Detail Rows Expression defined for a measure and returns the data	1236	Completed	DETAILROWS([<measure_expression>])
TOPN	Table Manipulation	Returns the top N rows of the specified table	1232	Completed	TOPN(<n_value>, <table>, <orderBy_expression>, [<order>][, <orderBy_expression>, [<order>]]...)
SUBSTITUTEWITHINDEX	Table Manipulation	Returns a table where the values of the specified column are replaced with new values	1227	Completed	SUBSTITUTEWITHINDEX(<table>, <indexColumnName>, <indexTable>, [<orderBy_expression>, [<order>]]...)
FILTERS	Table Manipulation	Returns the values that are directly applied as filters to columnName	1229	Completed	FILTERS(<columnName>)
TREATAS	Table Manipulation	Treats the columns of the input table as columns from other tables	1228	Completed	TREATAS(<table_expression>, <column>[, <column>[, <column>[, ...]]])
INTERSECT	Table Manipulation	Returns the rows that are common between two tables	1231	Completed	INTERSECT(<table_expression1>, <table_expression2>)
EXCEPT	Table Manipulation	Returns the rows of left-side table which do not appear in right-side table	1230	Completed	EXCEPT(<table_expression1>, <table_expression2>)
NATURALLEFTOUTERJOIN	Table Manipulation	Performs a left outer join of a table with another table	1224	Completed	NATURALLEFTOUTERJOIN(<leftTable>, <rightTable>)
GENERATE	Table Manipulation	Returns a table with the Cartesian product between each row in table1 and the table that results from evaluating table2 in the context of the current row from table1	1225	Completed	GENERATE(<table1>, <table2>)
NATURALINNERJOIN	Table Manipulation	Performs an inner join of a table with another table	1223	Completed	NATURALINNERJOIN(<leftTable>, <rightTable>)
GENERATEALL	Table Manipulation	Returns a table with the Cartesian product between each row in table1 and the table that results from evaluating table2 in the context of the current row from table1	1226	Completed	GENERATEALL(<table1>, <table2>)
UNION	Table Manipulation	Creates a union (join) table from a pair of tables	1222	Completed	UNION(<table_expression1>, <table_expression2> [,<table_expression>]...)
ROW	Table Manipulation	Returns a table with a single row containing values that result from the expressions given to each column	1219	Completed	ROW(<name>, <expression>[, <name>, <expression>]...)
CROSSJOIN	Table Manipulation	Returns a table that contains the Cartesian product of all rows from all tables in the arguments	1221	Completed	CROSSJOIN(<table1>, <table2> [,<table3>]...)
DATATABLE	Table Manipulation	Returns a table with data defined inline	1220	Completed	DATATABLE (ColumnName1, DataType1, ColumnName2, DataType2..., {{Value1, Value2...}, {ValueN, ValueN+1...}...})
SELECTCOLUMNS	Table Manipulation	Returns a table with selected columns from the table and new columns specified by the DAX expressions	1218	Completed	SELECTCOLUMNS(<table>, [<name>], <expression>[, [<name>], <expression>]...)
ADDCOLUMNS	Table Manipulation	Adds calculated columns to the given table or table expression	1217	Completed	ADDCOLUMNS(<table>, <name>, <expression>[, <name>, <expression>]...)
PATH	Parent-Child	Returns a delimited text with the identifiers of all the parents to the current row, starting with the oldest/top parent and ending with the current row's identifier	1212	Completed	PATH(<ID_columnName>, <parent_columnName>)
PATHITEMREVERSE	Parent-Child	Returns the item at the specified position from a string resulting from evaluation of a PATH function	1215	Completed	PATHITEMREVERSE(<path>, <position>[, <type>])
PATHLENGTH	Parent-Child	Returns the number of parents to the specified item in a given PATH result, including self	1216	Completed	PATHLENGTH(<path>)
PATHCONTAINS	Parent-Child	Returns TRUE if the specified item exists within the specified path	1213	Completed	PATHCONTAINS(<path>, <item>)
PATHITEM	Parent-Child	Returns the item at the specified position from a string resulting from evaluation of a PATH function	1214	Completed	PATHITEM(<path>, <position>[, <type>])
NOT	Logical	Changes FALSE to TRUE, or TRUE to FALSE	1210	Completed	NOT(<logical>)
AND	Logical	Checks whether both arguments are TRUE, and returns TRUE if both arguments are TRUE	1208	Completed	AND(<logical1>, <logical2>)
ISBLANK	Information	Checks whether a value is blank, and returns TRUE or FALSE	1211	Completed	ISBLANK(<value>)
OR	Logical	Checks whether one of the arguments is TRUE to return TRUE	1209	Completed	OR(<logical1>, <logical2>)
CLOSINGBALANCEYEAR	Time Intelligence	Returns the value of the expression at the last date of the year in the current context	1207	Completed	CLOSINGBALANCEYEAR(<expression>, <dates>, [<filter>], [<year_end_date>])
WINDOW	Filter	Returns multiple rows which are positioned within the given interval	1198	Completed	WINDOW(<from>, <to>, <relation>, [<orderBy_expression>], [<blanks>], [<partitionBy_expression>])
CLOSINGBALANCEMONTH	Time Intelligence	Returns the value of the expression at the last date of the month in the current context	1206	Completed	CLOSINGBALANCEMONTH(<expression>, <dates>, [<filter>])
ORDERBY	Filter	Defines the columns that determine the sort order within WINDOW, OFFSET, INDEX and other functions	1199	Completed	ORDERBY(<orderBy_expression>, [<order>], [<orderBy_expression>], [<order>]…)
MOVINGAVERAGE	Filter	Returns a moving average of expression, evaluated row by row, for a specified number of rows	1202	Completed	MOVINGAVERAGE(<expression>, <window_size>, [<orderBy_expression>], [<partitionBy_expression>])
PARTITIONBY	Filter	Defines the columns that are used to partition a window function's <relation> parameter	1200	Completed	PARTITIONBY([<columnName>], [<columnName>]…)
OPENINGBALANCEWEEK	Time Intelligence	Returns the value of the expression at the first date of the week in the current context	1203	Completed	OPENINGBALANCEWEEK(<expression>, <dates>, [<filter>], [<week_end_day>])
CLOSINGBALANCEWEEK	Time Intelligence	Returns the value of the expression at the last date of the week in the current context	1205	Completed	CLOSINGBALANCEWEEK(<expression>, <dates>, [<filter>], [<week_end_day>])
RUNNINGSUM	Filter	Returns a running sum of expression, evaluated row by row, for the given table	1201	Completed	RUNNINGSUM(<expression>, [<orderBy_expression>], [<partitionBy_expression>])
RANGE	Filter	Returns a table with a single column containing values from start_position to end_position	1197	Completed	RANGE(<start_position>, <end_position>)
OPENINGBALANCEMONTH	Time Intelligence	Returns the value of the expression at the first date of the month in the current context	1204	Completed	OPENINGBALANCEMONTH(<expression>, <dates>, [<filter>])
ALLCROSSFILTERED	Filter	Clear all filters which are applied to a table	1191	Completed	ALLCROSSFILTERED(<table>)
EARLIEST	Filter	Returns the current value of the specified column in an outer evaluation pass of the mentioned column	1193	Completed	EARLIEST(<column>)
ALLNOBLANKROW	Filter	From the parent table of a relationship, returns all rows but the blank row, or all distinct values of a column but the blank row	1190	Completed	ALLNOBLANKROW(<table>\|<column>)
OFFSET	Filter	Returns a single row that is positioned either before or after the current row within the same table	1196	Completed	OFFSET(<delta>, <table>, [<orderBy_expression>], [<order>], [<blanks>], [<partitionBy_expression>])
VALUES	Filter	When the input parameter is a column name, returns a one-column table that contains the distinct values from the specified column	1188	Completed	VALUES(<TableNameOrColumnName>)
EARLIER	Filter	Returns the current value of the specified column in an outer evaluation pass of the mentioned column	1192	Completed	EARLIER(<column>, [<number>])
KEEPFILTERS	Filter	Modifies how filters are applied while evaluating a CALCULATE or CALCULATETABLE function	1187	Completed	KEEPFILTERS(<expression>)
LOOKUPVALUE	Filter	Returns the value in result_columnName for the row that meets all criteria specified by search_columnName and search_value	1194	Completed	LOOKUPVALUE(<result_columnName>, <search_columnName>, <search_value>, [<search2_columnName>, <search2_value>]…)
SELECTEDVALUE	Filter	Returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult	1189	Completed	SELECTEDVALUE(<columnName>[, <alternateResult>])
INDEX	Filter	Returns a row at an absolute position (specified by position) within the specified partition (sorted by the specified order or by the expression)	1195	Completed	INDEX(<position>, <table>, [<orderBy_expression>], [<order>], [<partitionBy_expression>])
PREVIOUSYEAR	Time Intelligence	Returns a table that contains a column of all dates in the previous year, based on the first date in the dates column	1177	Completed	PREVIOUSYEAR(<dates>, [<year_end_date>])
CALCULATETABLE	Filter	Evaluates a table expression in a modified filter context	1181	Completed	CALCULATETABLE(<expression>, [<filter1>], [<filter2>]…)
LASTDATE	Time Intelligence	Returns the last date in the current context for the specified column of dates	1179	Completed	LASTDATE(<dates>)
FILTER	Filter	Returns a table that represents a subset of another table or expression	1182	Completed	FILTER(<table>, <filter>)
FIRSTDATE	Time Intelligence	Returns the first date in the current context for the specified column of dates	1178	Completed	FIRSTDATE(<dates>)
ALLSELECTED	Filter	Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied inside the query, but keeping filters that come from outside	1184	Completed	ALLSELECTED([<tableName>\|<columnName>])
REMOVEFILTERS	Filter	Clear filters from the specified tables or columns	1186	Completed	REMOVEFILTERS([<table>\|<column>[, <column>[, <column>[, …]]]])
ALL	Filter	Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied	1183	Completed	ALL([<table>\|<column>[, <column>[, <column>[,…]]]])
ALLEXCEPT	Filter	Removes all context filters in the table except filters that have been applied to the specified columns	1185	Completed	ALLEXCEPT(<table>, <column>[, <column>[, …]])
CALCULATE	Filter	Evaluates an expression in a modified filter context	1180	Completed	CALCULATE(<expression>, [<filter1>], [<filter2>]…)
PREVIOUSMONTH	Time Intelligence	Returns a table that contains a column of all dates from the previous month, based on the first date in the dates column	1175	Completed	PREVIOUSMONTH(<dates>)
ENDOFYEAR	Time Intelligence	Returns the last date of the year in the current context for the specified column of dates	1167	Completed	ENDOFYEAR(<dates>, [<year_end_date>])
NEXTDAY	Time Intelligence	Returns a table that contains a column of all dates representing the day that follows the first date in the dates column	1168	Completed	NEXTDAY(<dates>)
PREVIOUSQUARTER	Time Intelligence	Returns a table that contains a column of all dates in the previous quarter, based on the first date specified in the dates column	1176	Completed	PREVIOUSQUARTER(<dates>)
NEXTWEEK	Time Intelligence	Returns a table that contains a column of all dates from the next week, based on a column of dates	1169	Completed	NEXTWEEK(<dates>, [<week_end_day>])
NEXTYEAR	Time Intelligence	Returns a table that contains a column of all dates in the next year, based on the first date in the dates column	1172	Completed	NEXTYEAR(<dates>, [<year_end_date>])
PREVIOUSDAY	Time Intelligence	Returns a table that contains a column of all dates representing the day that follows the first date in the dates column	1173	Completed	PREVIOUSDAY(<dates>)
NEXTMONTH	Time Intelligence	Returns a table that contains a column of all dates from the next month, based on the first date in the dates column	1170	Completed	NEXTMONTH(<dates>)
NEXTQUARTER	Time Intelligence	Returns a table that contains a column of all dates in the next quarter, based on the first date specified in the dates column	1171	Completed	NEXTQUARTER(<dates>)
PREVIOUSWEEK	Time Intelligence	Returns a table that contains a column of all dates from the previous week, based on a column of dates	1174	Completed	PREVIOUSWEEK(<dates>, [<week_end_day>])