List of Functions
All built-in functions are listed here. Click on a function for more information, links will open in a new tab or browser window for convenience.
Aggregate
- AggAvg
- AggCount
- AggDistinctCount
- AggMax
- AggMin
- AggSum
- RunningSum
- AggMedian v2017.2+
- AggMode v2017.2+
- AggStandardDeviation v2017.2+
- AggVariance v2017.2+
Financial
Date
- Date
- DateAdd
- DateCustomFormat
- DateDiff
- DateValue
- Day
- DayOfWeekName v2021.1+
- DayOfWeekNumber v2021.1+
- Days360
- GlobalDateFormat
- GlobalDateTimeFormat
- Hour
- Minute
- Month
- MonthName v2017.2+
- Now
- QuarterName v2017.2+
- QuarterNumber v2017.2+
- Second
- Time
- TimeFormat1
- TimeValue
- Today
- WeekOfYear v2021.1+
- Year
Arithmetic & Geometric
- Abs
- Acos
- Acosh
- Asin
- Asinh
- Atan
- Atan2
- Atanh
- Ceiling
- Cos
- Cosh
- Even
- Exp
- Fixed
- Floor
- GlobalNumericFormat
- Int
- Ln
- Log
- Log10
- Mod
- Odd
- Pi
- Power
- Product
- Quotient
- Rand
- Round
- Sin
- Sinh
- Sqrt
- Tan
- Tanh
- Truncate
Formatting
String
Operators
& and / concatenate
+ plus
- minus
* multiply
/ divide