VBA functions in MDX and DAX
Collapse the table of content
Expand the table of content

VBA functions in MDX and DAX

 

Updated: March 2, 2016

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.

Function NameSupportedNotes
AbsDAX, MDX
ArrayNot supported
AscMDX only
AscWMDX only
AtnMDX only
CallByNameNot supported
CBoolMDX only
CByteMDX only
CCurMDX only
CDateMDX only
CDblMDX only
CDecMDX only
ChooseMDX only
ChrMDX only
CIntMDX only
CLngMDX only
CLngLngNot supported
CLngPtrNot supported
CommandNot supported
CosMDX only
CreateObjectNot supported
CSngMDX only
CStrMDX only
CurDirNot supported
CVarMDX only
CVErrNot supported
DateMDX 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
DateAddMDX only** Warning ** DAX implements a different function with the same name; the DATEADD (<dates>,<number_of_intervals>,<interval>) function, used to shift the given dates by a number of given intervals
DateDiffMDX only
DatePartMDX only
DateSerialMDX only
DateValueDAX, MDX
DayDAX, MDX
DDBMDX only
DirNot supported
DoEventsNot supported
EnvironNot supported
EOFNot supported
ErrorNot supported
ExpDAX, MDX
FileAttrNot supported
FileDateTimeNot supported
FileLenNot supported
FilterNot 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
FixMDX only
Format (Visual Basic for Applications)DAX, MDX
FormatCurrencyNot supported
FormatDateTimeNot supported
FormatNumberNot supported
FormatPercentNot supported
FreeFileNot supported
FVMDX only
GetAllSettingsNot supported
GetAttrNot supported
GetObjectNot supported
GetSettingNot supported
HexMDX only
HourDAX, MDX
IifMDX only** Warning ** DAX implements a similar function with the name: IF (logical_test, value_if_true, value_if_false) function.
IMEStatusNot supported
InputNot supported
InputBoxNot supported
InStrMDX only
InStrRevNot supported
IntDAX, MDX
IPmtMDX only
IRRMDX only
IsArrayMDX only
IsDateMDX only
IsEmptyMDX only
IsErrorDAX, MDX
IsMissingMDX only
IsNullMDX only
IsNumericMDX only
IsObjectNot supported
JoinNot supported
LBoundNot supported
LCaseMDX only
LeftDAX, MDX
LenDAX, MDX
LocNot supported
LOFNot supported
LogMDX 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.
LTrimMDX only
MacIDNot supported
MacScriptNot supported
MidDAX, MDX
MinuteDAX, MDX
MIRRMDX only
MonthDAX, MDX
MonthNameNot supported
MsgBoxNot supported
NowDAX, MDX
NPerMDX only
NPVMDX only
OctMDX only
PartitionMDX only
PmtMDX only
PPmtMDX only
PVMDX only
QBColorMDX only
RateMDX only
ReplaceNot supported
RGBMDX only
RightDAX, MDX
RndMDX only
RoundDAX, MDX
RTrimMDX only
SecondDAX, MDX
SeekNot supported
SgnDAX, MDX
ShellNot supported
SinMDX only
SLNMDX only
SpaceMDX only
SpcNot supported
SplitNot supported
SqrMDX only
StrMDX only
StrCompMDX only
StrConvMDX only
StringMDX only
StrReverseNot supported
SwitchMDX only
SYDMDX only
TabNot supported
TanMDX only
TimeNot supported
TimerMDX only
TimeSerialMDX only
TimeValueDAX, MDX
TrimDAX, MDX
TypeNameMDX only
UBoundNot supported
UCaseMDX only
ValMDX only
VarTypeNot supported
WeekdayDAX, MDX
WeekdayNameNot supported
YearDAX, MDX

Community Additions

ADD
Show:
© 2016 Microsoft