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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Onyii
New Member

How do I calculate Length of Service from given this dataset using date of hire or date of terminat

I have column for Date of Hire, Date of termination , and Last performance review date. How do I get length of service from these data?

 

 

 

 

 

 

1 REPLY 1
TotunG
Resolver I
Resolver I

Hi,

 

This is done with the DATEDIFF function. You can use this function by making a new column and then follow the instructions here: 

 

https://learn.microsoft.com/en-us/dax/datediff-function-dax

 

Essentially it takes 2 dates and works out the difference between them. You can specify what unit of measurement you want this difference to be in e.g. Years, Days etc. 

 

Please accept as solution if this helped.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.