Employee Tenure Band Calculate

Hi, 

Hi, I have a table like the one below.

What I want to do is calculate the tenure banding (1-3 Year xxx employee, 3-5 year xxx employee exc.) for both the leavers and the employees.

I would be glad if you can assist.

Tenure Term = CALCULATE(AVERAGEX('Turn Over', ROUNDDOWN(DATEDIFF('Turn Over'[Term Date],'Turn Over','Turn Over'[Term Date],MONTH)/12,0))FILTER('Turn Over','Turn Over'[Employee]=0))

how can I combine them? Or how i calculate in power query?