Forum Discussion

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...

amitchandak
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

Helper V

5 years ago

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