Forum Discussion
Counting active users, joiners & leavers
Hello everyone, I'm relatively new to PowerBI, and I've done a fair amount of research and tried different approaches without success. The idea is to show how many people joined the company in a particular month, how many left, and the number of active users in a specific month/year.
I have a table with user information with columns id, start date, and end date, and I want to create a clustered column chart with three categories:
- users with a start date in the current month named "Joiners".
- users with an end date in the current month named "Leavers".
- users with a start date before the current month and an end date blank named "Active".
Data looks like this, when an user is still active, then End Date is blank.
ID Start Date End Date
1312313 01/23/2020 12/24/2021
1231231 08/15/2021 09/01/2022
2534556 12/20/2022
4356546 01/01/2023 04/20/2023
2534556 10/12/2021
4356546 02/13/2020
This is an example of what I'm trying to get. Would you help me with that or point me in the right direction? Any help will be highly appreciated.
6 Replies
- NaveenGandhiMemorable Member
Hello johan-svitla
How would you define current month, Will you be using a slicer?
Also if start_date & end_date falls on current month, What would be the status.Regards,
Naveen
- johan-svitlaRegular Visitor
Hi. Yes, the slicer would be my choice. If someone joined and left in the same month should be counted in both joiners and leavers.
Regards and thanks for your interest
- NaveenGandhiMemorable Member
johan-svitla
Id 4356546 has two entries, can you let me know what should be the desired output in such cases?