Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
@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!
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.
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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.