FixVersion Report with Release Date and Prior FixVersion Release Date

[Speedydgon]

Trying to create a report showing the Release Date for each FixVersion and then the release date for the prior release.

Screen shot below of calculated measure in the FixVersion Dimension to filter and order the desired list of FixVersions.

Screen shot below of calculated measure in the Measures Dimension to try to get the prior FixVersion Release Date.

Screenshot of desired report showing error.

As you can see I have tried PrevMember but cannot get it to work. I think this is a simple thing but cannot figurer it out. Help

[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

[Speedydgon]

The -2 is the part I needed. Got it working. And just in time as we use this for some end of month release metrics so it will come in handy for May. Thank you so much!

[jts1984]

Will this show the prior release date after selecting ‘Released’ and picking a new release date for that specific FixVersion?

@gerda.grantina