AVERAGEA
The AVERAGEA function returns the arithmetic mean of the values in a column considering texts and non-numeric values.
USERNAME
The USERNAME function returns the domain and name of the user from the credentials given to the system at the time of connection.
SUMMARIZECOLUMNS
The SUMMARIZECOLUMNS function returns an aggregated table according to a set of fields, being able to apply filters to the input values.
CALCULATETABLE
The CALCULATETABLE function evaluates an expression that generates a table in a context modified by the filters passed as arguments.
PRODUCTX
The PRODUCTX function returns the product of the values taken by an expression that is evaluated for all rows in a table.
GEOMEANX
The GEOMEANX function returns the geometric mean of the values returned by an expression that is evaluated for all the rows of a table.
GEOMEAN
The GEOMEAN function returns the geometric mean of the numbers in a column.
SELECTEDVALUE
The SELECTEDVALUE function returns the content of the indicated column when the context has reduced the number of distinct values to one. Otherwise it returns the alternative value or Blank if it has not been added as an argument.
