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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

Average Time in Status



I have an applicant workflow and would like to measure how long a candidate has spent in which status (per job and average across all jobs). I have the following table:

Job Req IDApplication IDApplication StatusApplication Status CategoryCreated Date (Timestamp)Is Current StatusSkipped Status
3003842388666Personal AssessmentASSESSMENT22.05.2023 06:21 Skipped by user
3003842388666Cultural fit assessmentASSESSMENT22.05.2023 06:21 Skipped by user
3003842388666Manager ReviewASSESSMENT22.05.2023 06:21 Not Skipped
3003842388666Rejected - Direct RejectedCLOSED22.05.2023 09:23YESNot Skipped
3003842388666ScreeningSCREENING22.05.2023 06:21 Skipped by user
3003842388666DefaultAPPLIED19.05.2023 14:34 Not Skipped
3003842388666Recruiter InterviewSCREENING22.05.2023 06:21 

Skipped by user


If the status is "Skipped by user", the applicant was not in this status, if it is "not skipped", the applicant was in this status. For the case shown, I would want to know how long the applicant was in the status "Default" and "Manager Review". If "CLOSED", then I do not need any time.


I would be very grateful if anyone can help.


Kind regards


Frequent Visitor

Anybody there with a solution for this?

Community Support
Community Support

Hi @checkner ,


Could you please tell me what's the expected results according your sample data provided?

And this is the Power Query forum, You want a solution in Power Query, not a solution for DAX in Power BI Destkop, right?


Best Regards,

Stephen Tao


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

Hi @v-stephen-msft

I would like to evaluate for each workflow step how long the candidates spent on average in which status, then break this down for each position. At the end, I would like to display the average value (per step) in my recruiting dashboard as a card and/or diagram. 


I am therefore not sure whether Power Query or PowerBI Desktop is the right solution. 

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors