Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Dear All,
Can someone help me to convert below excel formula to DAX formula. I'm trying to calculate employee tenure
=IF([@[FINAL_PROCESS_DATE]]<>"",SUM(SUM([@[FINAL_PROCESS_DATE]]-[@HIREDATE])/365),SUM(NOW()-[@HIREDATE])/365)
Regards,
tenure =
var enddate = if ([final_process_date] = blank(), today(),[final_process_date])
return datediff ([hiredate],enddate,DAY)/365
Might need to use null rather than blank dependent on exactly what your data types are
Thanks. but its not working. error in Today()
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 6 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 9 | |
| 8 | |
| 8 | |
| 8 |