Forum Discussion

johan-svitla's avatar
johan-svitla
Regular Visitor
3 years ago
Solved

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 part...
Need Help
NaveenGandhi's avatar
NaveenGandhi
Icon for Memorable Member rankMemorable Member
3 years ago

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-svitla's avatar
    johan-svitla
    Regular Visitor
    3 years ago

    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

    • NaveenGandhi's avatar
      NaveenGandhi
      Icon for Memorable Member rankMemorable Member
      3 years ago

      johan-svitla 

      Id 4356546  has two entries, can you let me know what should be the desired output in such cases?

      • johan-svitla's avatar
        johan-svitla
        Regular Visitor
        3 years ago

        Hi, this is a mistake on the sample data. IDs are unique and are never duplicated under any circumstance