Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

active users over a period

Hi, I have a requirement where i need to find the count of active user per month/Qtr/Year based on slicer selection from the sample data attached here.The active or inactive status is described by F...
Need Help
Show and Tell
lbendlin's avatar
lbendlin
Super User
5 years ago

Having a monthly budget number will help if you can also to have month based user license terms. 

 

How likely is it for users to have start or end dates within a month, and can that be ignored? Say the factual start date is September 20 but for the report it would be treated as September 1?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

The factual start date will always be month begining and the end date will never be within the month.

Example of use case in the dataset-

User John started on Jan 2020,and quits by Jul 2020.

The he is rehired in Oct 2020 and stays until Dec 2023.

 

Thanks a lot for looking into it.Please help with this request.

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Attached is the modified pbix.  I modified the data model and prepared the budget measure but will leave it as an exercise for you to decide what to do with the totals and how to handle periods other than months.  Calculating total active users across applications doesn't make much sense to me.

     

    Please also note the changes that I made to simplify some of your calculated columns.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks a lot for your help.Really appreciate it.I will look your solution and get back for any Qs.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I looked into the model and see that the total active users measure does not show the count whereas the cost shows up fine.Can you please help.

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support
        5 years ago

        Hi Anonymous ,

         

        Please show the formula of the measure and related screenshots.

         

        Best regards,
        Lionel Chen

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Has your problem been solved?

    If not , what is the expected output of the matrix when the slicer selects ‘2020-05’?

     

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.