DAX Functions Supported through SQL Connectivity

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