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
CurrentMember
IsLevel
Right
CurrentTuple
IsMatch
Round
DateDiff
IsSibling
RTrim
DatePart
IsUda
Siblings
DateRoll
IsValid
Stddev
DateToMember
Item
Stddevp
DefaultMember
JulianDate
StrToMbr
Descendants
Lag
StrToNum
Distinct
LastChild
Subset
Dimension
LastPeriods
Substring
DrilldownByLayer
LastSibling
Sum
DrilldownMember
Lead
Tail
DrillupByLayer
Leaves
Todate
DrillupMember
Left
TodateEx
DTS
Len
Today
EnumText
Level
TopCount
EnumValue
Levels
TopPercent
Except
LinkMember
TopSum
Exp
Ln
Truncate
Extract
Log
TupleRange
Factorial
Log10
Uda
Filter
Lower
Union
FirstChild
LTrim
UnixDate
FirstSibling
Max
Upper
FormatDate
Median
Value
Generate
MemberRange
WithAttr
Generation
Members
WithAttrEx
xTD