SUM() : SUM([Sales]) : Total of a numeric field across partition

AVG() : AVG([Discount]) : Average value

MIN() : MIN([Order Date]) : Earliest or smallest value

MAX() : MAX([Profit]) : Latest or greatest value

COUNT() : COUNT([Order ID]) : Number of non-null records

COUNTD() : COUNTD([Customer ID]) : Distinct count of a field

ATTR() : ATTR([Region]) : Return value if consistent else*

TOTAL() : TOTAL(SUM([Sales])) : Grand total within table calc grouping

ZN() : ZN([Profit]) : Convert NULL to zero

SIZE() : SIZE() : Number of rows in the partition