Skip to main content

Function List

NameTypeDescription
STRING_TO_ARRAYText
LEFTText
LENText
JSONPATHText
JSON_ARRAY_ELEMENTSText
RIGHTText
SUBSTITUTEText
LOWERText
CONTAINSSTRINGText
PIVOTINDEXTable manipulation
ADDCOLUMNTable manipulation
UNIONTable manipulation
ASCTable manipulation
TOPNTable manipulation
ORDERBYTable manipulation
SELECTCOLUMNSTable manipulation
GENERATESERIESTable manipulation
SUMMARIZECOLUMNSTable manipulation
ASTable manipulation
DESCTable manipulation
INTMath
CONVERTMathConvert an expression to the specified data type.
CEILINGMath
ABSMathReturns the absolute value of a number.
RANDMath
NOTLogical
ISBLANKLogical
ORLogicalThe OR function returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.
ISEMPTYLogical
ISINRANGELogical
IFLogicalReturns one value if a logical expression is TRUE and another if it is FALSE.
CASELogical
ANDLogicalThe AND function returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.
CREATERELATIONSHIPFilter
CALCULATEFilterEvaluates an expression in a context modified by filters.
ALLSELECTEDFilter
ALLROWFilter
RELATEDFilter
ALLFilter
FILTERFilterReturns a table that has been filtered.
SELECTEDVALUEFilter
CROSSFILTERFilter
DATEVALUEDate and Time
NOWDate and Time
WEEKDAYDate and TimeReturns a number representing the day of the week of the date provided.
FORMATDate and TimeConverts a value to text in the specified format.
DATEDate and TimeConverts a year, month, and day into a date.
HOURDate and Time
DATEADDDate and TimeMoves the given date by a specified interval.
YEARDate and Time
DATEDIFFDate and TimeReturns the number of units (unit specified in Interval) between the input two dates.
MONTHDate and Time
CONCATENATEXAggregation
MINXAggregation
COUNTXAggregation
SUMXAggregation
COUNTROWSAggregation
CUMULATIVEAggregation
AVERAGEXAggregation
MAXXAggregation
EXPLORE
UNNEST
BLANK