Reference

Mathematical

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

Text

• LOWER
• CONCAT
• LEFT
• MID
• REGEXEXTRACT
• REGEXMATCH
• REGEXREPLACE
• RIGHT
• SEARCH
• TEXT
• TEXTJOIN
• VALUE
• LEN
• LENG
• LOCALVALUE
• TRIM

Miscellaneous

• COALESCE
• LOOKUP

Date/Time

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

Statistical

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

Logical

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

Table

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

Geographic

• GREAT_CIRCLE

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!