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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Yuliana

I have a similar problem listed in the query, however each month I receive a new export of employees, which I have appended and added to the bottom of my table.

Is this possible to create a measure that will incorporate this. From this I understand I would possible need a new measure for each month?

Link to my query below with source files

https://community.powerbi.com/t5/Desktop/Track-movement-of-employees-Attrition-and-movers/td-p/896860