Filter Current Month by Weeks

Questions & Answers
2

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.

image
image.png1262×706 77.1 KB

Best,
Zane / support@eazyBI.com