Locate Epic Creation Datetime for Tasks

Questions & Answers
, ,
1

Hello,
This is my first time using this community, so apologies if i miss any important information off.

I am trying to create a table which shows a list of issues - what i would like to locate against each issue is the date when the linked epic is created.
I thought that using FILTER could potentially provide me with what i need as i already have the epic name in [Measures].[Issue Epic Link] ([Issue].CurrentHierarchyMember.get(‘Epic Link’)). But i have been unable to get what i need using this feature.
Please can someone advise me how i would do this.
Thanks
James

2

Hi @JamesA

Welcome to the eazyBI community!

You may create a new measure (in Measures) where you retrieve the epic link creation date from the Issue dimension corresponding epic issue (with the same key as the epic link key):

[Issue].[Issue].GetMemberByKey([Measures].[Issue Epic Link]).GetDate("Created at")

Set Date formatting!

Read more about GetMemberByKey function: GetMemberByKey

Best,
Ilze, support@eazybi.com