Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Calculating Employee Age by Month

Hi   Please see link to dummy file below: https://1drv.ms/u/s!AkENRXlfBIJKig49BFN8Y8DQwgJ5?e=v3DW0w   I am struggling to create a measure that calculates the age of an Employee at any given date...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

TheoC 

Hi Theo

 

Still struggling on with this one, but now using the age measure below.  On its own, it calculating correctly as at  each month start, but its then a question as to how do I link to the cohorts identified by either Current Role and Current Head measures and then apply average??

 

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    Hi Anonymous 

     

    I believe it may have to do with the data itself. This is the only thing I can put it down to.

     

    I am so sorry I couldn't be of more assistance!