Skip to main content

Function List

NameTypeDescription
ROW_NUMBERWindow
OVERWindow
CONTAINSSTRINGText
REGEXP_MATCHText
USERAGENTText
JSON_ARRAY_ELEMENTSText
JSONPATHTextAllows to navigate and retrieve specific data from JSON objects or arrays based on a specified path or query.
LEFTText
STRING_TO_ARRAYText
LENText
SUBSTITUTEText
RIGHTText
LOWERText
DESCTable manipulation
TOPNTable manipulation
SELECTCOLUMNSTable manipulation
SUMMARIZECOLUMNSTable manipulation
ASTable manipulation
GENERATESERIESTable manipulation
ASCTable manipulation
UNIONTable manipulation
PIVOTINDEXTable manipulation
ORDERBYTable manipulation
CONVERTMathConvert an expression to the specified data type.
CEILINGMath
ABSMathReturns the absolute value of a number.
INTMath
RANDMath
IFLogicalReturns one value if a logical expression is TRUE and another if it is FALSE.
NOTLogical
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.
CASELogical
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.
ISINRANGELogical
ISBLANKLogical
ISEMPTYLogical
CALCULATEFilterEvaluates an expression in a context modified by filters.
ALLROWFilter
FILTERFilterReturns a table that has been filtered.
KEEPFILTERSFilterEvaluates an expression in a context modified by filters.
SELECTEDVALUEFilter
ALLFilter
CROSSFILTERFilter
CREATERELATIONSHIPFilter
ALLSELECTEDFilter
RELATEDFilter
DIMENSIONExpressionsConvert an measure to the dimension.
DATEADDDate and TimeMoves the given date by a specified interval.
DAYDate and Time
DATEVALUEDate and Time
HOURDate and Time
FORMATDate and TimeConverts a value to text in the specified format.
DATEDIFFDate and TimeReturns the number of units (unit specified in Interval) between the input two dates.
WEEKDAYDate and TimeReturns a number representing the day of the week of the date provided.
YEARDate and Time
NOWDate and Time
DATEDate and TimeConverts a year, month, and day into a date.
MONTHDate and Time
MINXAggregation
CUMULATIVEAggregation
AVERAGEXAggregation
CONCATENATEXAggregation
SUMXAggregation
SUMAggregation
COUNTROWSAggregation
COUNTXAggregation
MAXXAggregation
BLANK
UNNEST
EXPLORE