...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note The functions CALENDAR and CALENDARAUTO support for creating a new table. |
...
Spark SQL functions for creating a new measure
...
| Anchor | ||||
|---|---|---|---|---|
|
The table below presents a list of Spark SQL functions
...
for creating a new measure.
And
...
IF
...
Not
...
OR
...
Switch
...
True and False
...
Blank
...
Fixed
...
ISO.CEILING
...
LOG10
...
MOD
...
MROUND
...
PI
...
POWER
...
QUOTIENT
...
RAND
...
Round
...
ROUNDDOWN
...
ROUNDUP
...
SIGN
...
SQRT
...
SUMX
...
DEGREES
...
DIVIDE
...
EVEN
...
Fact
...
FLOOR
...
GCD
...
LCM
...
LN
...
LOG
...
ODD
...
RADIANS
...
RANDBETWEEN
...
TRUNC
...
ISBLANK
...
ISBLANK
...
USERNAME
...
CONTAINS
...
ISERROR
...
ISEVEN
...
ISLOGICAL
...
ISNONTEXT
...
ISNUMBER
...
ISODD
...
ISTEXT
...
TODAY
...
NOW
...
DATEVALUE
...
DATESBETWEEN
...
DATESINPERIOD
...
DATESMTD
...
DATESQTD
...
DATESYTD
...
ENDOFMONTH
...
ENDOFQUARTER
...
ENDOFYEAR
...
FIRSTDATE
...
FIRSTNONBLANK
...
LASTDATE
...
LASTNONBLANK
...
NEXTDAY
...
PREVIOUSDAY
...
STARTOFMONTH
...
STARTOFQUARTER
...
STARTOFYEAR
...
TOTALMTD
...
TOTALQTD
...
TOTALYTD
...
ALL
...
ALLEXCEPT
...
ALLNOBLANKROW
...
ALLSELECTED
...
CALCULATE
...
CALCULATETABLE
...
DISTINCT
...
FILTER
...
FILTERS
...
HASONEFILTER
...
HASONEVALUE
...
ISCROSSFILTERED
...
ISFILTERED
...
RELATEDTABLE
...
SELECTEDVALUE
...
VALUES
...
COUNT
...
COUNTA
...
COUNTAX
...
COUNTROWS
...
COUNTX
...
DISTINCTCOUNT
...
DATE
...
...
Spark SQL functions for creating a new column
...
| Anchor | ||||
|---|---|---|---|---|
|
The table below presents a list of Spark SQL functions
...
for creating a new column.
And
...
IF
...
Not
...
OR
...
Switch
...
True and False
...
DATEDIFF
...
DAY
...
MONTH
...
TIME
...
YEAR
...
Len
...
Lower
...
Mid
...
Trim
...
Upper
...