Track 'new' users per month based on conditions

[Stuquan]

Hi,

I am trying to create a line graph that will show absolute new users per month based on their assigned user mapping.

My criteria are if the users are either a 'Developer', 'Report Viewer' or 'Report Creator'. I already have the following code working for each mapped type to give me the total number of users based on a calculated mapping column in my 'logs' table, this code then works through each activity in the mapping and counts the values up, if the user hits the 'dataset developer' value then they are a developer, if they only hit the report viewer and creator, then they are a creator and so on:

Dataset Developer Count = 
        VAR _Activities =
            ADDCOLUMNS (
                VALUES ( Logs[UserKey] ),
                "Report Viewer Activities", CALCULATE ( COUNTROWS ( Logs ), Logs[Mapping] = "Report Viewer" ),
                "Report Creator Activities", CALCULATE ( COUNTROWS ( Logs ), Logs[Mapping] = "Report Creator" ),
                "Dataset Developer Activities", CALCULATE ( COUNTROWS ( Logs ), Logs[Mapping] = "Dataset Developer" )
            )
        VAR _Logic =
            ADDCOLUMNS (
                _Activities,
                "User Type",
                    SWITCH (
                        TRUE (),
                        [Dataset Developer Activities] > 0 && [Report Creator Activities] > 0, "Dataset & Report Developer",
                        [Dataset Developer Activities] > 0, "Dataset Developer",
                        [Report Creator Activities] > 0, "Report Creator",
                        [Report Viewer Activities] > 0, "Report Viewer"
                    )
            )
        VAR _Count =
            COUNTROWS ( FILTER ( _Logic, [User Type] = "Dataset Developer" ) )
        RETURN
            _Count

I'm struggling with the time intelligence aspect of this. How can I keep this same logic, but show it for a month on month basis for only new users so that they are not counted again in the following month?

[lbendlin]

Why would the "new user" property be impacted by the activity type?

[Stuquan]

Hey @lbendlin, thanks for taking the time to reach out.

I need to see each of the three categories new users for each month. The logic above filters out the three different categories based on activity e.g.  if the same person views and develops, they will be categorised as a developer only that's why I need to separate the different user types because the same person could appear as a viewer and developer and in this scenario I would only want their 'highest rank' e.g. developer if they have been developing. 

Hope that makes sense.

[lbendlin]

Remember that SWITCH() stops at the first match - use that to your advantage.

Think about scenarios when they change roles between months. How do you plan to handle that?