Forum Discussion

Brianoreilly's avatar
Brianoreilly
Icon for Helper II rankHelper II
7 years ago

Employee Attrition Non Standard Calculation. Need Help!

Hi Folks,    I have a problem calculating Employee Attrition and retention in my Org.  Reasoning being, that it is a non standard way.    I currently have a WB that is calculating the standard w...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Brianoreilly,

 

After testing with your sample file, I have worked outsome of your requirements.

 

But you need an extra calendar table which is unrelated to the Employee Table. Then, add date field from the second calendar table into slicer.

count (month) =
DATEDIFF ( MIN ( 'Calendar2'[Date] ), MIN ( 'Calendar'[Date] ), MONTH ) + 1

Cumulative Leavers End Headcount =
SUMX (
    FILTER (
        ALLSELECTED ( 'Calendar' ),
        'Calendar'[Year Month] <= MIN ( 'Calendar'[Year Month] )
    ),
    [Total leavers]
)

Best regards,

Yuliana Gu

  • Brianoreilly's avatar
    Brianoreilly
    Icon for Helper II rankHelper II
    7 years ago

    Hi Yuliana, 

     

    I can't seem to get this to work. 

     

    Could you send me on your solution file. 

     

     

    Would be really appreciated. 

     

    Thanks. 

    Brian