Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |