DAX Functions Supported through SQL Connectivity
This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here. |
|---|
Following is a list of DAX functions supported through SQL connectivity:
Blank
Len
Lower
Mid
Trim
Upper
Fixed
And
IF
Not
OR
Switch
True and False
IFERROR
ABS
CEILING
EXP
INT
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
CALENDAR
CALENDARAUTO
DATE
DATEDIFF
DAY
MONTH
TIME
YEAR