Reference

Mathematical

• ADD (+)
• CEIL
• DIVIDE (/)
• FLOOR
• MULTIPLY (*)
• POWER
• SUBTRACT (-)

Geographic

• GREAT_CIRCLE

Miscellaneous

• COALESCE
• LOOKUP

Date/Time

• ADDDATE
• DATE
• DAY
• DAYS
• MONTH
• NOW
• QUARTER
• TODAY
• YEAR
• YEARFRAC

Statistical

• AVERAGE
• AVERAGEX
• COUNT
• COUNTDISTINCT
• COUNTDISTINCTX
• COUNTX
• FIRST
• LAST
• MAX
• MAXX
• MIN
• MINX
• SUM
• SUMX

Text

• CONCAT
• LEFT
• MID
• REGEXEXTRACT
• REGEXMATCH
• REGEXREPLACE
• RIGHT
• SEARCH
• TEXT
• VALUE

Logical

• AND (&&)
• EQUAL (==)
• GREATER (>)
• GREATER OR EQUAL (>=)
• IF
• ISBLANK
• ISNUMBER
• LESS (<)
• LESS OR EQUAL (<=)
• NOT (!)
• NOT EQUAL (!=)
• OR (||)

Table

• ADDCOLUMNS
• FILTER
• PIVOTLONGER
• SELECTCOLUMNS
• SUMMARIZE
• UNION

Did you find what you were looking for?

Yes No

Thank you for your feedback!
Sorry you didn’t find what you were looking for. Please let us know if there is anything in particular you were missing from this page so we can improve our documentation. Submit

Your feedback has been submitted!