New and lost employee RRS feed

  • Question

  • Hello everyone,

     I want to write a measure, which describes New, and Lost employee. I have 2 table, table1 with employee_ID, Start_date and End_date and Table2 with Date. 

    * New employee is an employee who started working in this company in chosen period and have not been working here previously at least 90 days.

      *lost is an employee who is not working in this company more than 30 days. 

    Wednesday, July 10, 2019 8:29 AM