Forum Discussion
jacques_412
3 years agoFrequent Visitor
Filtering date ranges
I have a table of employees with a column for occupancy start date and a column for occupancy end date. If someone gets promoted or moves to a new department, a new row is created with a new start ...
amitchandak
3 years agoSuper User
jacques_412 , Refer if this approach can help
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
You can refer to the file attached after your signature
- jacques_4123 years agoFrequent Visitor
Thanks for this. It is not quite what I am looking for. Someone in the comment section of your Youtube video asked the same question a year ago, but there is no answer.