Help!!! Recreating this ticket for jira ticket age of power bi.

[HibaTalat]

Hey all,
I have created a date and from that, I can calculate the age of the ticket. The idea is to see which stage is problematic and I am want to calculate in form of #days

Following is the view I want for my dashboard:

Status 1	Average	Max	Min
Status 2	2	5	1
Status 3	5	89	1
Statsu4	9	3	1

Fast – the least amount of time ticket
stayed in this status

Slow- the max amount of time a ticket
stayed in this status

Average – the average amount of time a
ticket stayed in this status

Please note that I am new to PBI and I am using Desktop Report Server

[HibaTalat]

i have timestamp when a status moved from one state to another, I also have status_from and status_to  and jira ids.
I need to find the time when the status exit status_from

[freginier]

Do you have a ticket number on your table ? 

I think you need to create calculted columns with EARLIER function.

Like this :

Col_Max_date = CALCULATE ( max(TICKET_DATE), filter(earlier(ticket) = ticket ) ) 
Col_Min_date = CALCULATE ( min(TICKET_DATE), filter(earlier(ticket) = ticket ) ) 
Col_diff = DATEDIFF(Col_Min_date ,Col_Max_date, day)  

 tell me if you find what you want to do 

[freginier]

what step do you need help with ?