Forum Discussion
Solved
AVERAGE TENURE using CALCULATE FUNCTION
Hi Geeks, I am trying to calculate average tenure for all employees using a formula mentioned below: Points 1 - The table I am using is 'emp data' . I need to calculate difference between '...
AnonymousMany Thanks. I adjusted the formula as mentioned below and it worked
CALCULATE(AVERAGEX(Emp),
ROUNDDOWN(DATEDIFF(Table1[Group Entry Date],Table1[Reporting Date],MONTH)/12,0)))
The information you have provided is not making the problem clear to me. Can you please explain with an example. Can you share sample data and sample output.
In between refer my blog on HR that deal with how to find current employees :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Appreciate your Kudos.