Forum Discussion

FranckGbadamass's avatar
FranckGbadamass
Helper I
3 years ago

Multiple date column

Hello guys,

I need your precious help.

I'm struggling with PowerBI. I need to calculate the number of employees who left the company during the same month of the file uploading. You can find the sample_data through this link .I have uploaded 5 month of data.

 

Example: If we hired 500 associate in February_2023 how many left the company during the same month.

 

Thank you for help

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • olgad's avatar
    olgad
    Resident Rockstar
    3 years ago

    Hi, duplicate both colmns and transform to the month start

    Then, conditional column, if the value of updated and value of left are equal then it is a leaver.

     

  • olgad's avatar
    olgad
    Resident Rockstar
    3 years ago

    Hi, duplicate both colmns and transform to the month start

    Then, conditional column, if the value of updated and value of left are equal then it is a leaver.

     

  • olgad's avatar
    olgad
    Resident Rockstar
    2 years ago

    FranckGbadamass Have my answer or you yourself solved your problem? If so, can you please share your solution or accept my answer as Solution to help other members find it faster? Thank you very much for your kind cooperation!