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...
  • 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
    )