Forum Discussion
wnicholl
Resolver II
7 years agoTracking Employees from Month to Month
Data Scenario – We need to track employee movement from month to month. We are starting with a baseline file (Employee ID – Dec18) that has many employees; then we have monthly files (Employee ID – ...
- 7 years ago
Hi wnicholl ,
Please try this:
New Employees = EXCEPT ( VALUES ( 'Feb18_EmployeeRoster'[EmployeeID] ), VALUES ( 'Jan18_EmployeeRoster'[EmployeeID] ) )Best regards,
Yuliana Gu
- 7 years ago
Hi Yuliana - Thanks for repling to my post! I'll try your solution and let you know how it worked out.
- 7 years ago
Hi Yuliana - Thank you for your help. Your solutions worked great!! Thanks agian...
wnicholl
Resolver II
7 years agoHi Yuliana - Thank you for your help. Your solutions worked great!! Thanks agian...