Forum Discussion

CJ_96601's avatar
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_PROCE...
Help Requested
amitchandak's avatar
amitchandak
Super User
5 years ago

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

  • CJ_96601's avatar
    CJ_96601
    Helper V
    5 years ago

    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