Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi All,
I used the below DAX formula for the tenure calculation in PowerBI. But it gives wrong calculation for the Year.
For example someone who joined in 25 March 2019. Ideally it should be 3 Years and 10 Months. DAX formula gives 04 Years and 10 Months. Can someone help me correcting this formula?
Try
Tenure =
VAR EndingDate =
TODAY ()
VAR Mo =
MOD (
DATEDIFF (
'Active Headcount'[Continuous Service Sysco LABS (Internship/Contract/Permanent)],
EndingDate,
MONTH
),
12
)
VAR Yr =
QUOTIENT (
DATEDIFF (
'Active Headcount'[Continuous Service Sysco LABS (Internship/Contract/Permanent)],
EndingDate,
MONTH
),
12
)
VAR Tenure =
IF (
Yr > 0,
COMBINEVALUES ( " ", Yr, "Years", Mo, "Months" ),
COMBINEVALUES ( " ", Mo, "Months" )
)
RETURN
Tenure
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 9 | |
| 7 | |
| 6 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 17 | |
| 14 | |
| 13 |