DAXHub

Aggregation

DISTINCTCOUNTNOBLANK(<columnName>)

Counts the number of distinct values in a column

Aggregation

AVERAGEA(<columnName>)

Returns the average (arithmetic mean) of the values in a column

Aggregation

COUNTAX(<table>, <expression>)

Counts non-blank results when evaluating the result of an expression over a table

Aggregation

MINA(<columnName>)

Returns the smallest value in a column

Aggregation

MAXA(<columnName>)

Returns the largest value in a column

Aggregation

PRODUCTX(<table>, <expression>)

Returns the product of an expression evaluated for each row in a table

Aggregation

APPROXIMATEDISTINCTCOUNT(<columnName>)

Returns the approximate number of distinct values in a column

Aggregation

MAXX(<table>, <expression>)

Evaluates an expression for each row of a table and returns the largest numeric value.

Aggregation

MINA(<column>)

Returns the smallest value in a column, including any logical values and numbers represented as text.

Aggregation

PRODUCT(<column>)

Returns the product of the numbers in a column.

Aggregation

COUNTROWS(<table>)

Counts the number of rows in the specified table, or in a table defined by an expression.

Aggregation

COUNTX(<table>, <expression>)

Counts the number of rows that contain a number or an expression that evaluates to a number, when evaluating an expression over a table.

Aggregation

PRODUCTX(<table>, <expression>)

Returns the product of an expression evaluated for each row in a table.

Aggregation

COUNTA(<column>)

Counts the number of rows in the specified column that contain non-blank values. Supports Boolean values.

Aggregation

MAXA(<column>)

Returns the largest value in a column.

Aggregation

COUNTAX(<table>, <expression>)

Counts non-blank results when evaluating the result of an expression over a table.

Aggregation

DISTINCTCOUNTNOBLANK(<column>)

Counts the number of distinct values in a column.

Aggregation

DISTINCTCOUNT(<column>)

Counts the number of distinct values in a column.

Aggregation

AVERAGEX(<table>, <expression>)

Calculates the average (arithmetic mean) of a set of expressions evaluated over a table.

Aggregation

COUNTBLANK(<column>)

Counts the number of blank cells in a column.

Aggregation

AVERAGEA(<column>)

Returns the average (arithmetic mean) of the values in a column.

Aggregation

MINX(<table>, <expression>)

Returns the smallest numeric value that results from evaluating an expression for each row of a table.

Aggregation

APPROXIMATEDISTINCTCOUNT(<column>)

Returns an estimated count of unique values in a column.

Aggregation

COUNT(<column>)

Counts the number of rows in the specified column that contain non-blank values. Does not support Boolean values.

Aggregation

COUNT(<column>)

Counts the number of rows in the specified column that contain non-blank values

Aggregation

MAX(<column>)

Returns the largest value in a column

Aggregation

MIN(<column>)

Returns the smallest value in a column

Aggregation

AVERAGE(<column>)

Returns the average (arithmetic mean) of all the numbers in a column

Aggregation

SUMX(<table>, <expression>)

Returns the sum of an expression evaluated for each row in a table

Aggregation

DISTINCTCOUNT(<column>)

Counts the number of distinct values in a column

Aggregation

SUM(<column>)

Returns the sum of all the numbers in a column

Date and Time

NETWORKDAYS(<start_date>, <end_date>, [<holidays>])

Returns the number of whole workdays between two dates

Date and Time

DATEDIFF(<start_date>, <end_date>, <interval>)

Returns the count of interval boundaries crossed between two dates

Date and Time

YEARFRAC(<start_date>, <end_date>, [<basis>])

Calculates the fraction of the year represented by the number of whole days between two dates

Date and Time

HOUR(<datetime>)

Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.)

Date and Time

EDATE(<start_date>, <months>)

Returns the date that is the indicated number of months before or after the start date

Date and Time

WEEKDAY(<date>, [<return_type>])

Returns a number from 1 to 7 identifying the day of the week of a date

Date and Time

EOMONTH(<start_date>, <months>)

Returns the date in datetime format of the last day of the month, before or after a specified number of months

Date and Time

SECOND(<time>)

Returns the seconds of a time value

Date and Time

WEEKNUM(<date>, [<return_type>])

Returns the week number for the given date and year according to the return_type value

Date and Time

MINUTE(<datetime>)

Returns the minute as a number from 0 to 59, given a date and time value

Date and Time

QUARTER(<date>)

Returns the quarter as a number from 1 to 4

Date and Time

UTCNOW()

Returns the current date and time in Coordinated Universal Time (UTC)

Date and Time

CALENDAR(<start_date>, <end_date>)

Returns a table with a single column named "Date" that contains a contiguous set of dates

Date and Time

CALENDARAUTO([<fiscal_year_end_month>])

Returns a table with a single column named "Date" containing a contiguous set of dates

Date and Time

TIME(<hour>, <minute>, <second>)

Converts hours, minutes, and seconds given as numbers to an Excel serial number, formatted with a time format

Date and Time

UTCTODAY()

Returns the current date in Coordinated Universal Time (UTC)

Date and Time

TIMEVALUE(<time_text>)

Converts a time in text format to a time in datetime format.

Date and Time

UTCTODAY()

Returns the current UTC date.

Date and Time

WEEKDAY(<date>, [<return_type>])

Returns a number from 1 to 7 identifying the day of the week of a date.

Date and Time

HOUR(<datetime>)

Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).

Date and Time

DAY(<date>)

Returns the day of the month, a number from 1 to 31.

Date and Time

QUARTER(<date>)

Returns the quarter as a number from 1 to 4.

Date and Time

DATEVALUE(<date_text>)

Converts a date in the form of text to a date in datetime format.

Date and Time

MINUTE(<datetime>)

Returns the minute as a number from 0 to 59, given a date and time value.

Date and Time

SECOND(<datetime>)

Returns the seconds of a time value, as a number from 0 to 59.

Date and Time

YEARFRAC(<start_date>, <end_date>, [<basis>])

Calculates the fraction of the year represented by the number of whole days between two dates.

Date and Time

UTCNOW()

Returns the current UTC date and time

Date and Time

TIME(<hour>, <minute>, <second>)

Converts hours, minutes, and seconds given as numbers to a time in datetime format.

Date and Time

NETWORKDAYS(<start_date>, <end_date>, [<holidays>])

Returns the number of whole workdays between two dates.

Date and Time

CALENDAR(<start_date>, <end_date>)

Returns a table with a single column named "Date" that contains a contiguous set of dates.

Date and Time

EDATE(<start_date>, <months>)

Returns the date that is the indicated number of months before or after the start date.

Date and Time

EOMONTH(<start_date>, <months>)

Returns the date in datetime format of the last day of the month, before or after a specified number of months.

Date and Time

CALENDARAUTO([<fiscal_year_end_month>])

Returns a table with a single column named "Date" that contains a contiguous set of dates.

Date and Time

WEEKNUM(<date>, [<return_type>])

Returns the week number for the given date and year according to the return_type value.

Date and Time

DATEDIFF(<start_date>, <end_date>, <interval>)

Returns the number of interval boundaries between two dates.

Date and Time

NOW()

Returns the current date and time in datetime format

Date and Time

MONTH(<date>)

Returns the month as a number from 1 (January) to 12 (December)

Date and Time

DATEDIFF(<date1>, <date2>, <interval>)

Returns the number of interval boundaries between two dates

Date and Time

DATE(<year>, <month>, <day>)

Returns the specified date in datetime format

Date and Time

TODAY()

Returns the current date

Date and Time

YEAR(<date>)

Returns the year of a date as a four digit integer

Filter

WINDOW(<from>, <to>, <relation>, [<orderBy_expression>], [<blanks>], [<partitionBy_expression>])

Returns multiple rows which are positioned within the given interval

Filter

ORDERBY(<orderBy_expression>, [<order>], [<orderBy_expression>], [<order>]…)

Defines the columns that determine the sort order within WINDOW, OFFSET, INDEX and other functions

Filter

MOVINGAVERAGE(<expression>, <window_size>, [<orderBy_expression>], [<partitionBy_expression>])

Returns a moving average of expression, evaluated row by row, for a specified number of rows

Filter

PARTITIONBY([<columnName>], [<columnName>]…)

Defines the columns that are used to partition a window function's <relation> parameter

Filter

RUNNINGSUM(<expression>, [<orderBy_expression>], [<partitionBy_expression>])

Returns a running sum of expression, evaluated row by row, for the given table

Filter

RANGE(<start_position>, <end_position>)

Returns a table with a single column containing values from start_position to end_position

Filter

ALLCROSSFILTERED(<table>)

Clear all filters which are applied to a table

Filter

EARLIEST(<column>)

Returns the current value of the specified column in an outer evaluation pass of the mentioned column

Filter

ALLNOBLANKROW(<table>|<column>)

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

Filter

OFFSET(<delta>, <table>, [<orderBy_expression>], [<order>], [<blanks>], [<partitionBy_expression>])

Returns a single row that is positioned either before or after the current row within the same table

Filter

VALUES(<TableNameOrColumnName>)

When the input parameter is a column name, returns a one-column table that contains the distinct values from the specified column

Filter

EARLIER(<column>, [<number>])

Returns the current value of the specified column in an outer evaluation pass of the mentioned column

Filter

KEEPFILTERS(<expression>)

Modifies how filters are applied while evaluating a CALCULATE or CALCULATETABLE function

Filter

LOOKUPVALUE(<result_columnName>, <search_columnName>, <search_value>, [<search2_columnName>, <search2_value>]…)

Returns the value in result_columnName for the row that meets all criteria specified by search_columnName and search_value

Filter

SELECTEDVALUE(<columnName>[, <alternateResult>])

Returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult

Filter

INDEX(<position>, <table>, [<orderBy_expression>], [<order>], [<partitionBy_expression>])

Returns a row at an absolute position (specified by position) within the specified partition (sorted by the specified order or by the expression)

Filter

CALCULATETABLE(<expression>, [<filter1>], [<filter2>]…)

Evaluates a table expression in a modified filter context

Filter

FILTER(<table>, <filter>)

Returns a table that represents a subset of another table or expression

Filter

ALLSELECTED([<tableName>|<columnName>])

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

Filter

REMOVEFILTERS([<table>|<column>[, <column>[, <column>[, …]]]])

Clear filters from the specified tables or columns

Filter

ALL([<table>|<column>[, <column>[, <column>[,…]]]])

Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied

Filter

ALLEXCEPT(<table>, <column>[, <column>[, …]])

Removes all context filters in the table except filters that have been applied to the specified columns

Filter

CALCULATE(<expression>, [<filter1>], [<filter2>]…)

Evaluates an expression in a modified filter context

Filter

MATCHBY(<column>[, <column>]...)

In window functions, defines the columns that are used to determine how to match data and identify the current row.

Filter

ROWNUMBER([<orderBy>], [<partitionBy>], [<matchBy>], [<reset>])

Returns the unique ranking of a row within the given interval.

Filter

FIRST(<column>)

Used in visual calculations only. Retrieves a value in the visual matrix from the first row of an axis.

Filter

REMOVEFILTERS([<table> | <column>[, <column>[, ...]]])

Clears filters from the specified tables or columns.

Filter

PREVIOUS(<column>[, <steps>])

Used in visual calculations only. Retrieves a value in the previous row of an axis in the visual matrix.