topic AVG TENURE IN YEARS in DAX Commands and Tips

AVG TENURE IN YEARS

Easley06 — Tue, 06 Jun 2023 09:08:41 GMT

Hi,

i have measure for this avg tenure question is is this the right way on how to AVG this tenure

measure:

AVG Tenure days:=
"AVG " & CALCULATE(FORMAT(AVERAGEX(
VALUES(vw_Employee_Attrition[biometric id]),
CALCULATE(AVERAGE(vw_Employee_Attrition[Active Tenure year]))
),"##.0") & " Years",FILTER(vw_Employee_Attrition,vw_Employee_Attrition[IsActive] = 1))

active tenure year

= DATEDIFF(vw_Employee_Attrition[Hire Date],TODAY(),YEAR)

thanks.

Re: AVG TENURE IN YEARS

olgad — Tue, 06 Jun 2023 14:18:08 GMT

Are you only looking at the tenure of those who are still employed in the company?, if not, then you would need to identify leavers, and if it is a leaver then calculate date diff not versus today but the exit date and if it is an active headcount then tenure will be calculated the way you did.

Re: AVG TENURE IN YEARS

Easley06 — Wed, 07 Jun 2023 01:27:12 GMT

yes tenure whos still in the company. thanks.