Forum Discussion
Resolved date for tickets
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.2...
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])