Employee Turnover % by Month

// Truth is you don't have to limit the calculation
// to just a month. You can calculate what you want
// on ANY period of time. This will, of course,
// also work for months in particular.
// Please do NOT connect your Dates table to any
// of the fields in the Employees table.


[# Emps At Start Of Period] =
// These are emps that have
// hire date <= start of period
var __periodStart = MIN( Dates[Date] )
return
    CALCULATE(
        countrows( Employees ),
        KEEPFILTERS( Employees[Hire Date] <= __periodStart )
    )

[# Emps At End Of Period] =
// These are emps that have
// their hire date <= end of period
// and their termination date >=
// end of period.
var __periodEnd = MAX( Dates[Date] )
return
    CALCULATE(    
        countrows( Employees ),
        KEEPFILTERS( Employees[Hire date] <= __periodEnd ),
        KEEPFILTERS(
            Employees[Termination Date] >= __periodEnd
            ||
            isblank( Employees[Termination Date] )
        )
    )
    
[# Emps Terminated During Period] =
// self-explanatory
var __periodStart = MIN( Dates[Date] )
var __periodEnd = MAX( Dates[Date] )
return
    CALCULATE(
        countrows( Employees ),
        KEEPFILTERS( __periodStart <= Employees[Termination Date] ),
        KEEPFILTERS( Employees[Termination Date] <= __periodEnd )
    )