Title: MDX Function Reference  
Owner: Elvis Kvalbergs
Creator: Elvis Kvalbergs Mar 04, 2021
Last Changed by: Gvido Oct 09, 2024
Tiny Link: (useful for email) https://burti.atlassian.net/wiki/x/uwP04w
Export As: Word · PDF  
Flex.bi Support Center (4)
    Page: Create charts
    Page: Learn more
    Page: Main concepts
    Page: Regular expressions
Hierarchy
Children (72)
    Page: Aggregate
    Page: AllProperties
    Page: Ancestor
    Page: AnyDateInPeriod
    Page: Avg
    Page: Cache
    Page: CascadingChildrenSet
    Page: ChildrenSet
    Page: CoalesceEmpty
    Page: ConstantColumnValue
Labels
Global Labels (1)
Outgoing Links
External Links (1)
    mondrian.pentaho.com/documentation/mdx.php
Flex.bi Support Center (72)     Page: Count
    Page: Ytd
    Page: Item
    Page: Hierarchy
    Page: CurrentMember
    Page: DefaultMember
    Page: StartDate
    Page: DateBeforePeriodEnd
    Page: VisibleRowsSet
    Page: PreviousPeriods
    Page: Percentile
    Page: Dimension
    Page: SparklineData
    Page: DateDiffWorkhours
    Page: Instr
    Page: Ancestor
    Page: GetMemberByKey
    Page: Regular expressions
    Page: DateMember
    Page: FuturePeriods
    Page: Level
    Page: AnyDateInPeriod
    Page: Order
    Page: Val
    Page: DateInPeriod
    Page: Cache
    Page: Filter
    Page: LinRegPoint
    Page: Sum
    Page: CumulativeSum
    Page: DateCompare
    Page: DateSerial
    Page: DateWithoutTime
    Page: DateDiffWorkdays
    Page: DateAdd
    Page: CurrentHierarchy
    Page: Avg
    Page: SetToStr
    Page: CascadingChildrenSet
    Page: ConstantColumnValue
    Page: DateBetween
    Page: Round
    Page: ParallelPeriod
    Page: CoalesceEmpty
    Page: Generate
    Page: Tail
    Page: DateAddDays
    Page: DateDiffDays
    Page: DateAddWorkdays
    Page: ExtractString
    Page: Int
    Page: DefaultContext
    Page: DateAfterPeriodEnd
    Page: Aggregate
    Page: ConstantValue
    Page: IsEmpty
    Page: Now
    Page: DateParse
    Page: Descendants
    Page: ChildrenSet
    Page: Except
    Page: Calculated measures and members
    Page: CurrentDateMember
    Page: Rank
    Page: PreviousRowValue
    Page: CurrentHierarchyMember
    Page: NextStartDate
    Page: PrevMember
    Page: get
    Page: AllProperties
    Page: DateMembersBetween
    Page: Format