VBA functions in MDX and DAX

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This document contains a crossed reference of all VBA functions available in Microsoft Visual Basic for Applications Language Reference for Office 2010 that are supported in MDX; also, the list includes a note when there is functional equivalence with the DAX language.

Visual Basic for Applications Functions Reference

Function Name Supported Notes
Abs DAX, MDX
Array Not supported
Asc MDX only
AscW MDX only
Atn MDX only
CallByName Not supported
CBool MDX only
CByte MDX only
CCur MDX only
CDate MDX only
CDbl MDX only
CDec MDX only
Choose MDX only
Chr MDX only
CInt MDX only
CLng MDX only
CLngLng Not supported
CLngPtr Not supported
Command Not supported
Cos MDX only
CreateObject Not supported
CSng MDX only
CStr MDX only
CurDir Not supported
CVar MDX only
CVErr Not supported
Date MDX only ** Warning *\* DAX implements a different function with the same name; the DATE(Year, Month, Day) function, used to generate a date type value from the given arguments
DateAdd MDX only ** Warning *\* DAX implements a different function with the same name; the DATEADD (<dates>,,<interval>) function, used to shift the given dates by a number of given intervals
DateDiff MDX only
DatePart MDX only
DateSerial MDX only
DateValue DAX, MDX
Day DAX, MDX
DDB MDX only
Dir Not supported
DoEvents Not supported
Environ Not supported
EOF Not supported
Error Not supported
Exp DAX, MDX
FileAttr Not supported
FileDateTime Not supported
FileLen Not supported
Filter Not supported ** Warning *\* MDX implements a different function with the same name; the FILTER(Set_Expression, Logical_Expression) function returns the set that results from filtering a specified set based on a search condition from the given arguments

** Warning *\* DAX implements a different function with the same name; the FILTER (<table>,<filter>) function Returns a table that represents a subset of another table or expression from the given arguments
Fix MDX only
Format (Visual Basic for Applications) DAX, MDX
FormatCurrency Not supported
FormatDateTime Not supported
FormatNumber Not supported
FormatPercent Not supported
FreeFile Not supported
FV MDX only
GetAllSettings Not supported
GetAttr Not supported
GetObject Not supported
GetSetting Not supported
Hex MDX only
Hour DAX, MDX
Iif MDX only ** Warning *\* DAX implements a similar function with the name: IF (logical_test, value_if_true, value_if_false) function.
IMEStatus Not supported
Input Not supported
InputBox Not supported
InStr MDX only
InStrRev Not supported
Int DAX, MDX
IPmt MDX only
IRR MDX only
IsArray MDX only
IsDate MDX only
IsEmpty MDX only
IsError DAX, MDX
IsMissing MDX only
IsNull MDX only
IsNumeric MDX only
IsObject Not supported
Join Not supported
LBound Not supported
LCase MDX only
Left DAX, MDX
Len DAX, MDX
Loc Not supported
LOF Not supported
Log MDX only ** Important *\* DAX implements a different function with the same name; the LOG (number, base) function. Returns the logarithm of a number to the base specified from the given arguments.
LTrim MDX only
MacID Not supported
MacScript Not supported
Mid DAX, MDX
Minute DAX, MDX
MIRR MDX only
Month DAX, MDX
MonthName Not supported
MsgBox Not supported
Now DAX, MDX
NPer MDX only
NPV MDX only
Oct MDX only
Partition MDX only
Pmt MDX only
PPmt MDX only
PV MDX only
QBColor MDX only
Rate MDX only
Replace Not supported
RGB MDX only
Right DAX, MDX
Rnd MDX only
Round DAX, MDX
RTrim MDX only
Second DAX, MDX
Seek Not supported
Sgn DAX, MDX
Shell Not supported
Sin MDX only
SLN MDX only
Space MDX only
Spc Not supported
Split Not supported
Sqr MDX only
Str MDX only
StrComp MDX only
StrConv MDX only
String MDX only
StrReverse Not supported
Switch MDX only
SYD MDX only
Tab Not supported
Tan MDX only
Time Not supported
Timer MDX only
TimeSerial MDX only
TimeValue DAX, MDX
Trim DAX, MDX
TypeName MDX only
UBound Not supported
UCase MDX only
Val MDX only
VarType Not supported
Weekday DAX, MDX
WeekdayName Not supported
Year DAX, MDX