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!
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
1 Like