ROW_NUMBER | Window | |
OVER | Window | |
CONTAINSSTRING | Text | |
REGEXP_MATCH | Text | |
USERAGENT | Text | |
JSON_ARRAY_ELEMENTS | Text | |
JSONPATH | Text | Allows to navigate and retrieve specific data from JSON objects or arrays based on a specified path or query. |
LEFT | Text | |
STRING_TO_ARRAY | Text | |
LEN | Text | |
SUBSTITUTE | Text | |
RIGHT | Text | |
LOWER | Text | |
DESC | Table manipulation | |
TOPN | Table manipulation | |
SELECTCOLUMNS | Table manipulation | |
SUMMARIZECOLUMNS | Table manipulation | |
AS | Table manipulation | |
GENERATESERIES | Table manipulation | |
ASC | Table manipulation | |
UNION | Table manipulation | |
PIVOTINDEX | Table manipulation | |
ORDERBY | Table manipulation | |
CONVERT | Math | Convert an expression to the specified data type. |
CEILING | Math | |
ABS | Math | Returns the absolute value of a number. |
INT | Math | |
RAND | Math | |
IF | Logical | Returns one value if a logical expression is TRUE and another if it is FALSE. |
NOT | Logical | |
AND | Logical | The AND function returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. |
CASE | Logical | |
OR | Logical | The OR function returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false. |
ISINRANGE | Logical | |
ISBLANK | Logical | |
ISEMPTY | Logical | |
CALCULATE | Filter | Evaluates an expression in a context modified by filters. |
ALLROW | Filter | |
FILTER | Filter | Returns a table that has been filtered. |
KEEPFILTERS | Filter | Evaluates an expression in a context modified by filters. |
SELECTEDVALUE | Filter | |
ALL | Filter | |
CROSSFILTER | Filter | |
CREATERELATIONSHIP | Filter | |
ALLSELECTED | Filter | |
RELATED | Filter | |
DIMENSION | Expressions | Convert an measure to the dimension. |
DATEADD | Date and Time | Moves the given date by a specified interval. |
DAY | Date and Time | |
DATEVALUE | Date and Time | |
HOUR | Date and Time | |
FORMAT | Date and Time | Converts a value to text in the specified format. |
DATEDIFF | Date and Time | Returns the number of units (unit specified in Interval) between the input two dates. |
WEEKDAY | Date and Time | Returns a number representing the day of the week of the date provided. |
YEAR | Date and Time | |
NOW | Date and Time | |
DATE | Date and Time | Converts a year, month, and day into a date. |
MONTH | Date and Time | |
MINX | Aggregation | |
CUMULATIVE | Aggregation | |
AVERAGEX | Aggregation | |
CONCATENATEX | Aggregation | |
SUMX | Aggregation | |
SUM | Aggregation | |
COUNTROWS | Aggregation | |
COUNTX | Aggregation | |
MAXX | Aggregation | |
BLANK | | |
UNNEST | | |
EXPLORE | | |