Good afternoon. Can someone guide me on how to count headcount with week on week comparison, considering the joiners an leavers. Below is the sample table. EmpNoHIREDATEFINAL_PROCESS_DATEEmp 101/01/1011/25/10Emp 1002/01/10 Emp 1111/05/10 Emp 1202/02/11 Emp 1308/15/12 Emp 1408/05/13 Emp 1503/18/14 Emp 1603/15/15 Emp 1707/07/16 Emp 1802/25/17 Emp 1905/11/1310/10/17Emp 206/05/10 Emp 2007/07/17 Emp 304/02/1111/25/15Emp 406/15/12 Emp 503/05/13 Emp 603/18/1401/16/17Emp 709/15/15 Emp 801/07/1606/08/17Emp 902/25/14 Regards, Obet

CJ_96601 , refer if my HR blog can help https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970 Also might need help from this one Power BI — Week on Week and WTD https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123https://www.youtube.com/watch?v=pnAesWxYgJ8

Forum Discussion

CJ_96601

Helper V

5 years ago

Solved

Weekly Reporing

Good afternoon.

Can someone guide me on how to count headcount with week on week comparison, considering the joiners an leavers.

Below is the sample table.

EmpNo	HIREDATE	FINAL_PROCESS_DATE
Emp 1	01/01/10	11/25/10
Emp 10	02/01/10
Emp 11	11/05/10
Emp 12	02/02/11
Emp 13	08/15/12
Emp 14	08/05/13
Emp 15	03/18/14
Emp 16	03/15/15
Emp 17	07/07/16
Emp 18	02/25/17
Emp 19	05/11/13	10/10/17
Emp 2	06/05/10
Emp 20	07/07/17
Emp 3	04/02/11	11/25/15
Emp 4	06/15/12
Emp 5	03/05/13
Emp 6	03/18/14	01/16/17
Emp 7	09/15/15
Emp 8	01/07/16	06/08/17
Emp 9	02/25/14