Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply

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

3 REPLIES 3
olgad
Super User
Super User

@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!


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime
olgad
Super User
Super User

Hi, duplicate both colmns and transform to the month start

olgad_0-1676401032574.png

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

olgad_1-1676401126298.pngolgad_2-1676401153904.png

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime
olgad
Super User
Super User

Hi, duplicate both colmns and transform to the month start

olgad_0-1676401032574.png

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

olgad_1-1676401126298.pngolgad_2-1676401153904.png

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.