Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@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])