Constant Epic Due Date for each issue

Hi all,

For each epic un my project and each issue in my epic, I need to calculate the the time between the issue due date and the epic due date.
However, I can not get the Epic Due Date to calculate it.

If the issue are linked to the same epic, I would need that the date on the Epic Date Date column be equals for all issues.
More or less like the image below.

image

Any tips?

@Adriano

First, make sure you import “Epic link” field from the import options page.
https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-software-custom-fields#JiraSoftwarecustomfields-JiraSoftwarecustomfieldsimport

Then create a new calculated measure using this code:

CASE 

WHEN
NOT IsEmpty([Issue].CurrentHierarchyMember.Get("Epic Link"))
THEN
	CASE WHEN
	[Issue].Currenthierarchymember.Level.name = "Parent"
	THEN
	[Issue.Epic].CurrentMember.Parent.get("Due date")
	WHEN [Issue].Currenthierarchymember.Level.name = "Issue"
	THEN
	[Issue.Epic].[Epic].GetmemberByKey(
	[Issue].CurrentHierarchyMember.Get("Epic Link")
	).get("Due date")
	END
WHEN
[Measures].[issue type] = "Epic"
THEN
DateParse([Measures].[Issue due date])
END

Don’t forget to select the right output format for this measure.

And check the DateDiffDays function to calculate the difference in days between two dates.

Martins / eazyBI support