Aggregation functions
APPROXIMATEDISTINCTCOUNT Syntax
APPROXIMATEDISTINCTCOUNT(<columnName>)
AVERAGE Syntax
AVERAGE(<column>)
AVERAGEA Syntax
AVERAGEA(<column>)
AVERAGEX Syntax
AVERAGEX(<table>,<expression>)
SUM
Adds all the numbers in a column.
COUNT Syntax
COUNT(<column>)
COUNTA Syntax
COUNTA(<column>)
COUNTAX Syntax
COUNTAX(<table>,<expression>)
COUNTBLANK Syntax
COUNTBLANK(<column>)
COUNTROWS Syntax
COUNTROWS([<table>])
COUNTX Syntax
COUNTX(<table>,<expression>)
AVERAGEX
Calculates the average (arithmetic mean) of a set of expressions evaluated over a table.
COUNTAX
Counts non-blank results when evaluating the result of an expression over a table.
COUNTBLANK
Counts the number of blank cells in a column.
DISTINCTCOUNT
Counts the number of distinct values in a column.
DISTINCTCOUNTNOBLANK
Counts the number of distinct values in a column.
COUNT
Counts the number of rows in the specified column that contain non-blank values.
COUNTA
Counts the number of rows in the specified column that contain non-blank values.
COUNTROWS
Counts the number of rows in the specified table, or in a table defined by an expression.
COUNTX
Counts the number of rows that contain a number or an expression that evaluates to a number, when evaluating an expression over a table.
DISTINCTCOUNT Syntax
DISTINCTCOUNT(<column>)
DISTINCTCOUNTNOBLANK Syntax
DISTINCTCOUNTNOBLANK (<column>)
MAXX
Evaluates an expression for each row of a table and returns the largest numeric value.
MAX Syntax
MAX(<column>) MAX(<expression1>, <expression2>)
MAXA Syntax
MAXA(<column>)
MAXX Syntax
MAXX(<table>,<expression>)
MIN Syntax
MIN(<column>) MIN(<expression1>, <expression2>)
MINA Syntax
MINA(<column>)
MINX Syntax
MINX(<table>, < expression>)
PRODUCT Syntax
PRODUCT(<column>)
PRODUCTX Syntax
PRODUCTX(<table>, <expression>)
APPROXIMATEDISTINCTCOUNT
Returns the approximate number of rows that contain distinct values in a column.
AVERAGE
Returns the average (arithmetic mean) of all the numbers in a column.
AVERAGEA
Returns the average (arithmetic mean) of the values in a column.
MAX
Returns the largest numeric value in a column, or between two scalar expressions.
MAXA
Returns the largest value in a column.
PRODUCTX
Returns the product of an expression evaluated for each row in a table.
PRODUCT
Returns the product of the numbers in a column.
MIN
Returns the smallest numeric value in a column, or between two scalar expressions.
MINX
Returns the smallest numeric value that results from evaluating an expression for each row of a table.
MINA
Returns the smallest value in a column, including any logical values and numbers represented as text.
SUMX
Returns the sum of an expression evaluated for each row in a table.
SUM Syntax
SUM(<column>)
SUMX Syntax
SUMX(<table>, <expression>)
