Modeling EMPLOYEES

[ANM_97]

Hello,

I need to add work seniority (in years) in my dashboard. In this moment, my DIM_EMPLOYEES look like this:

SRC_ID	DIM_EMPLOYEE_ID	EMPLOYEE_NAME	EMPLOYEE_EMAIL	EMPLOYEE_PROFESSION	EMPLOYMENT_START_DATE	EMPLOYMENT_END_DATE	DATE_FROM	DATE_TO
1234562546125	40051	ANA ANNA	ana.anna@yahoo.ro	Risk Control Specialist	10/23/2018	NULL	10/23/18 12:00 AM	10/1/20 12:00 AM
1234562546125	48257	ANA ANNA	ana.anna@yahoo.ro	Business Intelligence Specialist	10/23/2018	NULL	10/8/21 11:57 AM	3/25/22 6:08 AM
1234562546125	51124	ANA ANNA	ana.anna@yahoo.ro	Acting Head of BI	10/23/2018	NULL	3/25/22 6:08 AM	NULL

How I can add employee seniority? 

Is another dimension necessary, because the frequency of recordings increases? 

Thanks,

Ana

[jcalheir]

Yes

Add a new calculated column to the table:

employee seniority = DATEDIFF(DIM_EMPLOYEE[EMPLOYMENT_START_DATE],TODAY(),YEAR)	

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂