Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |