Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Modeling EMPLOYEES

Hello,

 

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

 

SRC_IDDIM_EMPLOYEE_IDEMPLOYEE_NAMEEMPLOYEE_EMAILEMPLOYEE_PROFESSIONEMPLOYMENT_START_DATEEMPLOYMENT_END_DATEDATE_FROMDATE_TO
123456254612540051ANA ANNA[email protected]Risk Control Specialist10/23/2018NULL10/23/18 12:00 AM10/1/20 12:00 AM
123456254612548257ANA ANNA[email protected]Business Intelligence Specialist10/23/2018NULL10/8/21 11:57 AM3/25/22 6:08 AM
123456254612551124ANA ANNA[email protected]Acting Head of BI10/23/2018NULL3/25/22 6:08 AMNULL

How I can add employee seniority? 

 

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

 

Thanks,

Ana

 

Need Help
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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! 🙂