If you see this message, your browser either has disabled or does not support JavaScript. To use the full features of this help system, such as searching and the table of contents, your browser must have JavaScript support enabled. If your browser supports JavaScript, it provides settings that enable or disable JavaScript. When JavaScript is disabled, you can view only the content of the help topic, which follows this message.
MDX Function Reference
Consult the Contents pane for a list of MDX functions by return value.
Abs
Generations
Min
Aggregate
GetFirstDate
Mod
Ancestor
GetFirstDay
NextMember
Ancestors
GetLastDate
NonEmptyCount
Attribute
GetLastDay
NonEmptySubset
AttributeEx
GetNextDay
NTile
Avg
GetRoundDate
NumToStr
BottomCount
Head
OpeningPeriod
BottomPercent
Hierarchize
Order
BottomSum
IIF
Ordinal
Case
InStr
ParallelPeriod
CellValue
Int
Parent
Children
Intersect
Percentile
ClosingPeriod
Is
PeriodsToDate
CoalesceEmpty
IsAccType
Power
Concat
IsAncestor
PrevMember
Contains
IsChild
Rank
Count
IsEmpty
RealValue
Cousin
IsGeneration
RelMemberRange
CrossJoin
IsLeaf
Remainder
CurrentAxisMember
IsLevel
Right
CurrentMember
IsMatch
Round
CurrentTuple
IsSibling
RTrim
DateDiff
IsUda
Siblings
DatePart
IsValid
Stddev
DateRoll
Item
Stddevp
DateToMember
JulianDate
StrToMbr
DefaultMember
Lag
StrToNum
Descendants
LastChild
Subset
Distinct
LastPeriods
Substring
Dimension
LastSibling
Sum
DrilldownByLayer
Lead
Tail
DrilldownMember
Leaves
Todate
DrillupByLayer
Left
TodateEx
DrillupMember
Len
Today
DTS
Level
TopCount
EnumText
Levels
TopPercent
EnumValue
LinkMember
TopSum
Except
Ln
Truncate
Exp
Log
TupleRange
Extract
Log10
Uda
Factorial
Lower
Union
Filter
LTrim
UnixDate
FirstChild
Max
Upper
FirstSibling
Median
Value
FormatDate
MemberRange
WithAttr
Generate
Members
WithAttrEx
Generation
xTD