FixVersion Report with Release Date and Prior FixVersion Release Date

[gerda.grantina]

Hi @Speedydgon ,
You can take an idea from here on how to create the measure you are looking for:

Report with FixVersion Release Date and Next FixVersion Release Date

Hi, Lead’s construction looks for the next version using the dimension members’ default order, and it cannot see that your report refers to a specific calculated member. The following approach can fix that: ChildrenSet([Fix Version].[Last 7 releases]).Item( Rank( [Fix Version].CurrentMember, ChildrenSet([Fix Version].[Last 7 releases]) ) ).get('Release date') The formula’s idea is to use the Rank function to find the order number of the release in the Last seven releas…

To get the prior date you need to add -2 in the formula:

ChildrenSet([Fix Version].[Ordered release dates]).Item(
   Rank(
  [Fix Version].CurrentMember,
  ChildrenSet([Fix Version].[Ordered release dates])  
)-2  
).get('Release date')

In the report it looks like this:

best,
Gerda // support@eazyBI.com