Avg Employee Stay Month

[omkar_nag123]

Hii Community 

how we calculate Avg Employee Stay Month in HR Data.

[v-easonf-msft]

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

[amitchandak]

@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

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[amitchandak]

@omkar_nag123 ,

Try like

averagex(Values(Table[empID]) calculate(datediff(Min(Table[HireDate]), max(Table[termination date]) , day) ))