HASONEVALUE
The HASONEVALUE function returns the logical value True when the context has reduced the number of distinct values in the column indicated as an argument to one, and the logical value False in any other case.
SWITCH
The SWITCH function evaluates an expression and returns one result or another based on the value resulting from the evaluation, a value that will be found among a list of options.
SUMX
The SUMX function returns the sum of the values taken by an expression that is evaluated for all the rows in a table.
MINX
The MINX function returns the minimum value of the values that an expression takes that is evaluated for all the rows of a table.
MAXX
The MAXX function returns the maximum value taken by an expression that is evaluated for all rows in a table.
YEAR
The YEAR function returns the year of a date as an integer in the range 100-9999.
MONTH
The MONTH function returns the month of a date as an integer from 1 (corresponding to January) to 12 (corresponding to December).
DAY
The DAY function returns the day of a date as an integer from 1 to 31.
CONCATENATEX
The CONCATENATEX function concatenates the result of an evaluated expression for each row in a table. This expression can be the name of a column -in which case the function would concatenate the contents of the cells of that column- or a more complex expression that involves (or not) one or more columns of the table.
HOUR
The HOUR function returns the hour as a number from 0 (12 AM) to 23 (11 PM).
