Power BI: HR Analytics - Employees as on Date - userelationship , crossfilter, Hired/Terminated 

Thank you Amit..!! Quick and precise..!

Thanks for this very excellent video and the accompanying resources. Greatly appreciated.

Fantastic !!!! Thank You!!!

Really helpful Amit - straightforward explanations and easy to replicate, thank you for your help!

Thank you! That worked!

Easy to understand Thanks sir

Dear Amit, Thank you so much for this vedio. One help required desperately how to find current active employees growth from last date of previous year , your help make lots of love ❤

excellent video! was looking for something like this for ages. trying now to implement it. I'm using the same method to calculate how many projects were active on each day. each project has start date and end date. several questions: do the relations from both end date and start date in the project table to the date field in the calendar should be inactive? if yes, this is impacting other visuals in my report. any workaround? second question - seems I can't use any other slicers on the report page (i have slicers for project region for example). I was hoping i could use this to show a number of concurrent projects for each region.

Bravo! Amit. This video is very helpful. This works well as point-in-time counts of active cases across time in my human service work. I have a question for you. Besides the active employee counts, can you create a measure to show the average and median tenure (from hire date until current period start or end, in days) of the active employees in any period. Also can you also create the average age of employees if we have their birthdates? And a measure like average salarys?

Hi Amit, Thanks for the help, this was simple a really helpfull. It works excellent! I have a question, when I click on the table and in "Terminations", it shows me the hiring names, not the terminated ones, is there a way to solve it? Another question, is there a way to calculate the attrition rate or turnover using this numbers? Thanks a lot again!

Hi, how do i include a measure that looks at All Employees per month. i.e Terms + Hires + Current employees

Thank you Amit! How would you show the current headcount of employees for each month if the employees were in different departments, such as Engineering, HR, Logistics, Supply Chain using a stacked Bar chart?

I worked hard to get this video. For two weeks I have been trying to implement the same idea and failed. I will try it and give you the results.

Thanks for the great and easily explained video Amit. Just had one question, When I am replicating "Last Period Employee" measure, it is excluding count of employees who joined on that particular month. Where should I alter the dax to fix this? Thanks again!

Great video, please how do I add the “||“ or operator in power bi? What do I need to press on the keyboard to make it appear Coz tried everything it's not working at my computer

Hi Amit, Thanks for sharing the knowledge. However, I have a question as to how to calculate hire & terminations for any period based on all position history of staff. The last start date & end date acting as his recent position. Also, if he's continuing employee, the end date would be blank.

This helped me a lot.. Thanks :) Any idea how to get cumulative exits for the same as above with exit and join dates