Forum Discussion
Need Help with aggregating schedule appointment data
shris1993 , Refer to the file attached after the signature Active/Current Employee in HR is solved. In the same way you can solve this one
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
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZUHi amitchandak , Thank you so much for the reference. I am sure it will be a big help with my solution.
Hi shris1993 you can create Date table based on CALENDARAUTO function, check CALENDARAUTO function (DAX) - DAX | Microsoft Learn
After that create Date table as required in Power BI (mark as Date table) and after that create measure as you wish
Hi some_bih Yes , Thankyou , I created the date dimension table , but I am facing problem in connecting it with both the start date and end date in my fact table.
shris1993 , Refer to the file attached after the signature Active/Current Employee in HR is solved. In the same way you can solve this one
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
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZUHi amitchandak , Thank you so much for the reference. I am sure it will be a big help with my solution.