Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hello there,
I have a big dilemma I need to resolve and hope you can help me.
I have raw data that contain a list of tickets handled by L2, and L1 support (sometimes L2s are considered L1s as well and vice versa) I also have a "date of action" that registers when the ticket left the queue of a certain user (we can omit the hour). It's important to point out that one ticket may appear multiple times in a person's queue (because was reopened due to incomplete tasks). My question is how can I calculate the duration of the ticket by Receiver_ID, and by Support Levels from when the date landed in the receiver's queue by the assistant_ID until it left his or her queue?
For example, in the below case, I want to calculate the duration it took Herbert Swine to send the ticket back to Steve Colbert (Date of actions between rows 23784, and 9052)
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.