| SUM |
SUM(ColumnName) |
Returns the sum of all values in a column. |
| AVERAGE |
AVERAGE(ColumnName) |
Returns the average (arithmetic mean) of a column. |
| COUNT |
COUNT(ColumnName) |
Counts the number of numeric values in a column. |
| COUNTA |
COUNTA(ColumnName) |
Counts all non-blank values in a column. |
| COUNTROWS |
COUNTROWS(TableName) |
Counts the number of rows in a table or filtered table. |
| IF |
IF(LogicalTest, ResultIfTrue, ResultIfFalse) |
Returns one value if a condition is TRUE, another if FALSE. |
| CALCULATE |
CALCULATE(Expression, Filter1, Filter2, ...) |
Evaluates an expression with modified filters. |
| FILTER |
FILTER(Table, Condition) |
Returns a table with rows that meet a condition. |
| ALL |
ALL(ColumnName or TableName) |
Removes all filters from a column or table. |
| RELATED |
RELATED(ColumnName) |
Returns a value from a related table. |
| RELATEDTABLE |
RELATEDTABLE(TableName) |
Returns a table related to the current row. |
| DIVIDE |
DIVIDE(Numerator, Denominator, AlternateResult) |
Performs division and handles division by zero. |
| EARLIER |
EARLIER(Column, [N]) |
Accesses data from an earlier row context in calculations. |
| RANKX |
RANKX(Table, Expression, [Value], [Order]) |
Returns the rank of a value in a column or table. |
| VALUES |
VALUES(ColumnName) |
Returns a one-column table with distinct values from a column. |
| RELATED |
RELATED(ColumnName) |
Fetches a value from a related table based on relationships. |
| CONCATENATEX |
CONCATENATEX(Table, Expression, [Delimiter]) |
Concatenates values from a column or expression into a single string. |
| LOOKUPVALUE |
LOOKUPVALUE(Result_Column, Search_Column1, Search_Value1, ...) |
Returns a value in a column based on search criteria. |
| SWITCH |
SWITCH(Expression, Value1, Result1, Value2, Result2, ..., Else) |
Evaluates an expression against multiple values and returns a result. |
