Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I want to be able to calculate length of service based on active workers. I used DATEDIFF([Hire Date],[today],YEAR).
This gave me the whole numbers of the year ....but i want it to be able to break down so that if an employee has been with the company for 2 and a half years it will show up as 2.6 rather than just 2 years at the moment.
is this possible?
Thanks,
HS
Solved! Go to Solution.
what about try thsi
DATEDIFF([Hire Date],[today],MONTH) / 12 .
Proud to be a Super User!
You would be very close with
DIVIDE ( DATEDIFF([Hire Date],[today],DAY), 365)
If you want to keep it to 1 decimal do
ROUND(DIVIDE ( DATEDIFF([Hire Date],[today],DAY), 365),1)
what about try thsi
DATEDIFF([Hire Date],[today],MONTH) / 12 .
Proud to be a Super User!
It worked! Thank you
you are welcome
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |