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!
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.
Robert // eazyBI staff