Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Employee Turnover by month

Hi all,   I'm trying to have the turnover of employee by month (number of arrival - number of departure). I have two columns : Arrival date and Departure date (note that this column is empty if th...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Anonymous ,

     

    you should create a date table and connect it with one of the dates, for example Arrival Date. Then you can use the month from the date table and just count the rows of arrival to get the first measure.

     

    For the second measure (departure), you have to change the relationship in the measure with the USERELATIONSHIP function, count the rows and mulitply by -1.

    Then you should have the result you want.

     

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
Ahammedjaleel's avatar
Ahammedjaleel
Frequent Visitor
5 years ago

 

Please find same kind of report here

 

https://www.linkedin.com/posts/ahammed-jaleel-33772b5b_employee-performance-and-attrition-analysis-activity-6826427613427314688-ZnXC

 

the dax I used for turnover ration is as follows

Employee Turnover Ratio =
Var _Selectedvalue = [SelectedYear]
var _Lastyearcount = CALCULATE(COUNT(HRDataset_Final[EmpID]),HRDataset_Final[DateofHire - Year]<=_Selectedvalue-1)
var _CurrentYearCount = CALCULATE(COUNT(HRDataset_Final[EmpID]),HRDataset_Final[DateofHire - Year] <=_Selectedvalue)
var _ResignedEmployee = CALCULATE([Employees Terminated],FILTER(HRDataset_Final,HRDataset_Final [DateofHire - Year]=_Selectedvalue))
var _Avg= DIVIDE(_Lastyearcount+_CurrentYearCount,2,0)
RETURN
DIVIDE(_ResignedEmployee,_Avg,0)
let me know if you need any more  details