Forum Discussion

Brianoreilly's avatar
Brianoreilly
Helper 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
Microsoft 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
Helper 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