Mesure Mistake - Tenure

[ugurozdemir]

Hi,

Where am I making a mistake?

Tenure = (IF('Turn Over'[Acitve]=1, TODAY() - 'Turn Over'[Hire Date])/365),

                (IF('Turn Over'[Active]=0, 'Turn Over'[Term Date]-'Turn Over'[Hire Date]/365)

Thanks

[ugurozdemir]

Thank you so much @amitchandak 

[amitchandak · Accepted solution]

@ugurozdemir , Try like

Tenure = Switch( True(),
'Turn Over'[Acitve]=1,datediff('Turn Over'[Hire Date],today(),day)/365,
'Turn Over'[Active]=0, datediff('Turn Over'[Hire Date],'Turn Over'[Term Date], Day)/ 365
)