Filter Current Month by Weeks

[briantaylor]

I am looking to filter to capture the current month and sub-filter by weeks

Code:

Aggregate({
[Time.Weekly].[Week].CurrentDateMember
})

[zane.baranovska]

Hi @briantaylor,

Currently, eazyBI does not support monthly hierarchy represented by a set of weeks as one week might be split by two months. For this reason, we have two separate hierarchies, one to display dates by month and another by weeks.

In eazyBI backlog, we have a task to allow creating custom hierarchies in Time dimension. But we are still looking for the best solution on how to support this. My colleague or I will post a notification in this conversation when the feature is released and available for users.

Meanwhile, you may use calculated member in Time dimension and aggregate weeks of intereset.
For example, you may aggregate all weeks which start in the current month:

Aggregate(
  Filter([Time.Weekly].[Week].Members,
  DateBetween(
    --the first day of week
    [Time.Weekly].CurrentMember.StartDate,
    --between  the first date of current month
    DateSerial(Year(Now()),Month(Now()),1),
    --and the last date of current month
    DateAddDays(
      DateSerial(Year(Now()),Month(Now())+1,1)
      ,-1)
  )
))

Note that calculated member should be built-in Time dimension, weekly hierarchy.

Best,
Zane / support@eazyBI.com

[zane.baranovska]

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.

[gerda.grantina]

Hi @briantaylor ,
I wanted to let you know that we have released eazyBI version 7.0 recently. We included in this version an option to define custom time hierarchies. See the documentation for different examples: Custom time hierarchies

Please see a list of all changes: Changelog - eazyBI for Jira.

best,
Gerda // support@eazybi.com