Employee Turnover and total headcount

[Rui]

Hi 

I need to create a query to calculate the turnover (per month/qtd/ytd) based on below table.
I don't have a column to see if the employee is active or not, therefore i think i need to do something with the employee id.

Thnaks,

Rui

Date           ID             FTE

jan-18	1	1
jan-18	2	0,9
jan-18	3	1
jan-18	4	1
feb-18	1	1
feb-18	2	0,9
feb-18	3	1
feb-18	4	1
feb-18	5	0,5
mrt-18	1	1
mrt-18	2	0,9
mrt-18	4	1
mrt-18	5	0,5
mrt-18	6	1
apr-18	1	1
apr-18	2	0,9
apr-18	4	1
apr-18	5	0,5
apr-18	6	1
apr-18	7	1

[v-chuncz-msft]

@Rui,

You may check if the following post helps.

https://community.powerbi.com/t5/Desktop/Comparing-a-month-to-it-s-relative-previous-month-in-a-tabl...

[Rui · Accepted solution]

@ Sam

Thanks!