Forum Discussion

checkner's avatar
checkner
Frequent Visitor
3 years ago

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 ID ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.           

checkner's avatar
checkner
Frequent Visitor
3 years ago
Hi Anonymous

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.