We have a custom version field called “Planned Fix Version” that is assigned at the issue level. How can we get that Fix Version release date as a measure?
Hi @coachleigh,
eazyBI doesn’t import the Version IDs, even for the Version custom fields. To retrieve the release date from the Fix Version dimension members, you must find the particular member by name. If your versions have the same names across Projects and differing release dates, you may retrieve more results than desire with the calculated measure formula below:
Generate(
Filter(
[Fix Version].[Version].Members,
[Fix Version].CurrentMember.Name = [Planned Fix Version].CurrentMember.Name
),
[Fix Version].CurrentMember.GetString('Release date'),", "
)
Update the Planned Fix Version dimension name to fit your environment. See the expected result below:
Please look at our documentation page for more information on defining calculated measures - Calculated measures.
Best,
Roberts // support@eazybi.com
Thanks, Roberts!
I pasted the code in to a custom measure and unfortunately the date isn’t coming back. Both of these Fix Versions do have a target release. Any idea?
I’m assuming it’s because I am trying to tie it to an issue, so have the wrong hierarchy. I’ll play around with it!
Hi @coachleigh,
Your assumption is correct. The calculated measure I suggested expects the Planned Fix Version dimension in the report rows. I am sorry I didn’t emphasize that.
With the Issue dimension in the report rows, you can replace the [Planned Fix version].CurrentMember.Name expression with the issue property [Measures].[Issue Planned Fix Version] in the suggested formula.
Let me know how that goes.
Best,
1 Like
You are officially the hero of my QE leader!
1 Like
Hi @roberts.cacus I have a similar issue that I hope you may be able to help out with. We are trying to display the release for a fix version while using issues as the dimension the following code does not work
Generate(
Filter(
[Fix Version].[Version].Members,
[Fix Version].CurrentMember.Name = [Measures].[Issue fix versions]
),
[Fix Version].CurrentMember.GetString(‘Release date’),", "
)
I’d appreciate any advice you have for us!
