Fix Version by Release Date


#1

We’ve started adding release dates to our Fix Versions, which we synchronize across projects. I would like to create a custom member, on the Fix Version dimension, which will group all the Fix Versions with Release Date in a specific time range (we plan by 6-month windows). Is there a way to do this? Thanks!


#2

Hi @grandeau,

You could try to create a calculated member in the Fix Version dimension using the DateBetween function. Please have a look at the formula below:

Aggregate(
  Filter(
    [Fix Version].[Fix Version].Members,
    DateBetween([Fix Version].CurrentMember.get('Release date'), now(), '6 months from now')
  )
)

The function DateBetween returns if a date is between two other dates. It takes three parameters:

  • the date you are interested in;
  • the start date;
  • the end date.

Please have a look at our documentation page for more information about this function - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-members/mdx-function-reference/datebetween.

Best,
Robert // eazyBI staff