Club Power BI

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

How to calculate new hires

  • 1.  How to calculate new hires

    Posted Dec 01, 2021 09:05 AM

    Hello,

    I have the following table with several lines per employee.

    I would like to calculate the number of hires per period taking into account the first date and the associated function.
    and also terminations...

    For example below the hiring date are in bold.

    thank you

    employee

    Position

    Start Date

    End Date

    Bob

    Manager

    01/01/21

     

    Bob

    Senior

    5/5/20

    31/12/20

    Bob

    Junior

    01/01/20

    4/5/20

    Sam

    Junior

    4/4/20

     

    ...

     

     

     



    ------------------------------
    Oliv
    ------------------------------