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.
Hii Community
how we calculate Avg Employee Stay Month in HR Data.
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
@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
Try like
averagex(Values(Table[empID]) calculate(datediff(Min(Table[HireDate]), max(Table[termination date]) , day) ))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |