Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
ANM_97
Helper IV
Helper IV

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 ANNAana.anna@yahoo.roRisk Control Specialist10/23/2018NULL10/23/18 12:00 AM10/1/20 12:00 AM
123456254612548257ANA ANNAana.anna@yahoo.roBusiness Intelligence Specialist10/23/2018NULL10/8/21 11:57 AM3/25/22 6:08 AM
123456254612551124ANA ANNAana.anna@yahoo.roActing 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

 

1 REPLY 1
jcalheir
Solution Supplier
Solution Supplier

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.