# How to calculate date differences for specific issues

**URL:** <https://community.eazybi.com/t/how-to-calculate-date-differences-for-specific-issues/17535>\
**Category:** Questions & Answers\
**Tags:** jira-reports, jira\
**Created:** [June 20, 2024, 4:52pm UTC](https://community.eazybi.com/t/how-to-calculate-date-differences-for-specific-issues/17535 "2024-06-20T16:52:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![marcosEC](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/cdc98d/32.png) [@marcosEC](https://community.eazybi.com/u/marcosEC)\
**Post date:** [June 20, 2024, 4:52pm UTC](https://community.eazybi.com/t/how-to-calculate-date-differences-for-specific-issues/17535/1 "2024-06-20T16:52:25Z")

</div>

Hi everybody!  
I’m new at eazyBI and I’m trying to create a report with some statistics about my projects:

How could I calculate a measure to get the difference between this dates when an epic starts first time to status “Analysing” and finish in status “Deployed” (or now() if it doesn’t have this status yet)?

 ![image](https://community.eazybi.com/uploads/default/original/2X/b/bfcaf0a6cb7dd7e057bcb5bc839ad60afed33de8.png)

Thank you!

---

<div class="post-metadata">

**Author:** ![marcosEC](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/cdc98d/32.png) [@marcosEC](https://community.eazybi.com/u/marcosEC)\
**Post date:** [June 25, 2024, 11:21am UTC](https://community.eazybi.com/t/how-to-calculate-date-differences-for-specific-issues/17535/2 "2024-06-25T11:21:32Z")

</div>

Hi! I found something similar that I could use:

Avg(  
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),  
[Measures].[Issues created]\>0  
),  
DateDiffDays(  
([Measures].[Transition to status first date],  
[Transition Status].[Analysing],  
[Time].CurrentHierarchy.DefaultMember),  
([Measures].[Transition to status last date],  
[Transition Status].[Deployed],  
[Time].CurrentHierarchy.DefaultMember)  
)  
)