I need to calculate the total days of employment. Some employees have changed of employment agency and have therefore been provided a new employee_id. However I noticed that sometimes employee_id remains unchanged.
To calculate the days of employment I need your help on a measure. It should work like calculating the first startdate and last enddate, showing the total days so datediff( last enddate, first startdate, days)
Appreciate your help!