SQL Server (starting with 2012)
Azure SQL Database
Azure SQL Data Warehouse
Parallel 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>, |
| 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 |

