Forum Discussion
Calculating sum for 2 different dates
Hello
I have 2 differents datasets one contains employee id start date and end date
the other contains employees id and the year where he was a key people for the entreprise
i want to calculate the sum of leaves for the company for the last 12 months where leave date is in the same year where the employee was a key people
Solutions ? and thank you
2 Replies
Mannai , refer if the attached file can help.
Or these blogs can help
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/882970Hi Mannai ,
Could you please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards
