...
Spark SQL functions | New Measure | New Column |
|---|---|---|
And |
|
|
IF |
|
|
Not |
|
|
OR |
|
|
Switch |
|
|
True and False |
|
|
Blank |
| |
Len |
|
|
Lower |
|
|
Mid |
|
|
Trim |
|
|
Upper |
|
|
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 | CALENDAR | |
DATEDIFF |
| CALENDARAUTO |
DAY | |
|
MONTH |
|
|
TIME | DATE |
|
YEAR |
|
|
DATEDIFFLen |
|
|
DAYLower |
|
|
MONTHMid |
|
|
TIMETrim |
|
|
YEARUpper |
|
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note The functions CALENDAR and CALENDARAUTO support creating a new table. |