Averageif and max on period base

[Anonymous]

Hi all,

I have a dataset of users, one line per login and I am in need to:

1. Compare the average of user's login of the last 6 months with the average users with the same department have (each line has mentioned the department.
2. Compare the max of logins in the past 6 months with the logins of last month.

The current measures are:

Logins_per_user = DIVIDE(COUNT(PENDO_Visitors[Visitor ID]), DISTINCTCOUNT(PENDO_Visitors[Visitor ID]))

Total Logins Last 6 Months = 
CALCULATE (
   [Logins_per_user],
   DATESINPERIOD (
      'calendar'[Date],         
      MAX ( 'calendar'[Date] ), 
      -6,                
      MONTH                
    )
)

Average Logins Last 6 Months = [Total Logins Last 6 Months]/6

I can get the average per department just putting the Average Logins Last 6 Months next to the Department but how do I create those 2 measures?

[Anonymous]

Here an example, basically I need a measure like the one below so I can compare the average per department per month in the last 6 months (second table) with the average per user in the last 6 months (first table).

The max of logins of the last 6 months basically if user A had 2 logins in September, 3 in August, 1 in July, 1 in June, 1 in May, 4 in April should be 4 for that user.

An example of table could be 

User ID	Login Date	Department
ABC1	22/4/2022	Department 1
ABC1	26/4/2022	Department 1
ABC1	30/4/2022	Department 1
ABC1	16/8/2022	Department 1
ABC1	17/8/2022	Department 1
ABC1	17/7/2022	Department 1
ABC1	18/9/2022	Department 1
ABC2	15/4/2022	Department 1
ABC2	25/5/2022	Department 1
ABC2	13/6/2022	Department 1
ABC3	11/6/2022	Department 2
ABC3	26/8/2022	Department 2
ABC3	27/8/2022	Department 2
ABC4	15/7/2022	Department 2
ABC4	19/7/2022	Department 2
ABC4	28/8/2022	Department 2
ABC5	16/9/2022	Department 3

[Anonymous]

Hi @Anonymous ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_ Binbin Yu