Forum Discussion

ugurozdemir's avatar
ugurozdemir
Frequent Visitor
4 years ago
Solved

Mesure Mistake - Tenure

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
  • amitchandak's avatar
    amitchandak
    4 years ago

    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
    )

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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
    )