Resolved date for tickets

[macin]

Hi, 

I have following example list of jira tickets:

Key1 | To do | 01.01.2022
Key1 | In progress | 01.02.2022
Key1 | To do | 01.03.2022
Key1 | Won't do | 01.04.2022
Key1 | To do | 01.05.2022
Key1 | Done | 01.06.2022
Key1 | Done | 07.06.2022
Key1 | Done | 001.08.2022

Key2 | To do | 01.01.2022
Key2 | In progress | 01.02.2022
Key2 | To do | 01.03.2022
Key2 | Won't do | 01.04.2022
Key2 | To do | 01.05.2022
Key2 | Done | 01.06.2022
Key2 | Done | 07.06.2022
Key2 | Done | 001.08.2022

Expected

Key1 | 01.06.2022
Key2 | 01.06.2022

I would like to have following data

To do start date (earliest date)

In progress start date (earliest date)

Done date (latest done but earliest out of all done events).

Note: there is a possiblity that there are multiple consequitive Done statuses, I am interested only in the date against the Done status, which is later thna all other statuses that are not done.

I dont want to include Done dates which were Done at some point of time but afterwards they were reopened work done and then multiple tasks after done.What would you suggest?

I tried grouping but it always seems Iwill need to look at each row individually compared to previosy 

[amitchandak]

@macin , Try a measure like

new meausre =
var _max = maxx(filter(all(Table), Table[Key] = max(Table[Key]) && not(Table[Status] in {"Done"}) ), Table[Date])
return
Minx(filter(all(Table), Table[Key] = max(Table[Key]) && Table[Status] in {"Done"} && Table[Date] >_max ), Table[Date])