Forum Discussion
Avg Employee Stay Month
Hii Community
how we calculate Avg Employee Stay Month in HR Data.
3 Replies
- amitchandak
Super User
omkar_nag123 , Hope you have a termination date too, in that case only for a terminated employee
averagex(Values(Table[empID]) calculate(datediff([HireDate], [termination date] , day) ))
refer if needed
- amitchandak
Try like
averagex(Values(Table[empID]) calculate(datediff(Min(Table[HireDate]), max(Table[termination date]) , day) ))
- v-easonf-msft
Community Support
Hi., omkar_nag123
Could you please tell me whether your problem has beem solved?
If yes, you could accept the helpful answer as solution.
If not, please share more information and expected result.
Best Regards,
Community Support Team _ Eason
