Weekly Reporing

[CJ_96601]

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

Regards, 

Obet

[CJ_96601]

Any suggestions on how to count running total with distinct record .  there is a relationship between table and calendar

[amitchandak · Accepted solution]

@CJ_96601 , refer if my HR blog can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

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-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8

[CJ_96601]

Thanks.  @amitchandak 

I have questions about the Current Employee measure you used in the sample pbix

   1.  how to count distinct records

   2.  how to filter male and female 

Thanks