Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
macin
Frequent Visitor

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.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 

1 REPLY 1
amitchandak
Super User
Super User

@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])

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.