Filter Current Month by Weeks

Questions & Answers
3

There are two more elegant examples for calculated time members to represent current and previous month by weeks. You may use function DateMembersBetween() with relative dates or specified dates as well: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/datemembersbetween

  1. Current month by weeks

    Aggregate(
  [Time.Weekly].[Week].DateMembersBetween('first day of current month', 'today')
)

  2. Previous month by weeks

    Aggregate(
  [Time.Weekly].[Week].DateMembersBetween('first day of last month', 'firt day of current month')
)

In both cases, make sure that the calculated member is created Time dimension, weekly hierarchy.