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
checkner
Frequent Visitor

Average Time in Status

Hello,

 

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

Christoph

3 REPLIES 3
checkner
Frequent Visitor

Anybody there with a solution for this?

v-stephen-msft
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

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors
Top Kudoed Authors