Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Turnover - Monthly Data Headcount

Hello!    I started using Power Bi 2 months ago, as I was recruited as an People Analyst for a company with many employees.   Im currently struggling with a project and im really grateful for any...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    I can be understood as finding out the data that is not duplicated in the two tables, you can check the following results:

    Measure = CALCULATE(COUNT('new'[ID]),EXCEPT('new','old'))

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.