Forum Discussion

adhumal2's avatar
adhumal2
Icon for Helper III rankHelper III
6 years ago
Solved

AVERAGE TENURE using CALCULATE FUNCTION

Hi Geeks,   I am trying to calculate average tenure for all employees using a formula mentioned below:   Points  1 - The table I am using is 'emp data' . I need to calculate difference between '...
Need Help
  • adhumal2's avatar
    adhumal2
    6 years ago

    AnonymousMany Thanks. I adjusted the formula as mentioned below and it worked

     

    CALCULATE(AVERAGEX(Emp),

    ROUNDDOWN(DATEDIFF(Table1[Group Entry Date],Table1[Reporting Date],MONTH)/12,0))

    )

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

edhans - That is a fantastic post by ImkeF , I just added that post as a link in my blog article where I talk about posting data.

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

Yup Greg_Deckler - she just put that together over the last few days and mentined it in the Teams channel. I wish your post and her post could be made Stickies in the forums. They would get end users answers so much faster.