Want to look up the release date attached to the affects version dimension with the value from a custom measure

Questions & Answers
,
2

Hi @Davo

Welcome to the Community! :tada:

If you search in the Measures dimension for the property “Issue affects versions” and click the “show” button, you’ll see a formula that is really close to fitting your use case:

[Affects Version].[Version].getMemberNamesByKeys(
  [Issue].CurrentHierarchyMember.get('Affects version IDs')
)

You can adjust it a bit so that instead of getMemberNamesByKeys, you would use getMembersByKeys, and from these members, you can select the first item or .Item(0) (index 0 means the first in the list), then you can ask this first member for the Release date:

[Affects Version].[Version].getMembersByKeys(
  [Issue].CurrentHierarchyMember.get('Affects version IDs')
).Item(0).GetDate('Release date')

Let me know if this works as expected!
​Best regards,
​Nauris