Page tree
Skip to end of metadata
Go to start of metadata

case when [Time].Currenthierarchy.Level.Name="Month" OR

  ChildrenSet([Time].CurrentMember).Item(0).Level.Name="Month"

then

  sum(

    Childrenset([Time].CurrenthierarchyMember),

    Datediffworkdays(

      [Time].CurrenthierarchyMember.Startdate,

      [Time].CurrenthierarchyMember.NextMember.Startdate

    )

  )

end

  • No labels