Forum Discussion

wnicholl's avatar
wnicholl
Icon for Resolver II rankResolver II
7 years ago
Solved

Tracking 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 – ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi wnicholl ,

     

    Please try this:

    New Employees =
EXCEPT (
    VALUES ( 'Feb18_EmployeeRoster'[EmployeeID] ),
    VALUES ( 'Jan18_EmployeeRoster'[EmployeeID] )
)

     

    Best regards,

    Yuliana Gu

  • wnicholl's avatar
    wnicholl
    7 years ago

    Hi Yuliana - Thanks for repling to my post! I'll try your solution and let you know how it worked out.  

  • wnicholl's avatar
    wnicholl
    7 years ago

    Hi Yuliana - Thank you for your help. Your solutions worked great!!  Thanks agian... 

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi wnicholl ,

 

Please try this:

New Employees =
EXCEPT (
    VALUES ( 'Feb18_EmployeeRoster'[EmployeeID] ),
    VALUES ( 'Jan18_EmployeeRoster'[EmployeeID] )
)

 

Best regards,

Yuliana Gu

wnicholl's avatar
wnicholl
Icon for Resolver II rankResolver II
7 years ago

Hi Yuliana - Thanks for repling to my post! I'll try your solution and let you know how it worked out.  

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi wnicholl ,

     

    Have you worked it out?

     

    Regards,

    Yuliana Gu

    • wnicholl's avatar
      wnicholl
      Icon for Resolver II rankResolver II
      7 years ago

      We had some issues with our data source and subsequently required us to remove our data files. We should be receiving our new data files sometime this week. Thanks for reaching out. I'll touch base once we've tested.