VBA functions in MDX and DAX
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 Name |
Supported |
Notes |
||||
|---|---|---|---|---|---|---|
|
DAX, MDX |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
DAX, MDX |
|
|||||
|
DAX, MDX |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
DAX, MDX |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
DAX, MDX |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
DAX, MDX |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
DAX, MDX |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
DAX, MDX |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
DAX, MDX |
|
|||||
|
DAX, MDX |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
DAX, MDX |
|
|||||
|
DAX, MDX |
|
|||||
|
MDX only |
|
|||||
|
DAX, MDX |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
DAX, MDX |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
DAX, MDX |
|
|||||
|
MDX only |
|
|||||
|
DAX, MDX |
|
|||||
|
RTrim |
MDX only |
|
||||
|
DAX, MDX |
|
|||||
|
Not supported |
|
|||||
|
DAX, MDX |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
DAX, MDX |
|
|||||
|
DAX, MDX |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
MDX only |
|
|||||
|
MDX only |
|
|||||
|
Not supported |
|
|||||
|
DAX, MDX |
|
|||||
|
Not supported |
|
|||||
|
DAX, MDX |
|
Caution