topic Re: Average Calls per day, grouped by month in DAX Commands and Tips

Average Calls per day, grouped by month

Anonymous — Tue, 14 Jun 2022 22:56:20 GMT

How do you calculate the average of [wholds] in the month? Activity date is connected to a date table.

Idealy, Id like to be able to know how many [wholds] a Sales rep made per day based off the number of days in the month.

Essentially it would be the disctinct count of wholds in the month divided by the number of days in the month, and I could put it into a matrix/table that would know which month the calculation corresponds to.

Wholds	Activity Date
random numbers	04-10-22
random numbers	04-12-22
random numbers	03-06-22
random numbers	02-28-22

Re: Average Calls per day, grouped by month

tamerj1 — Wed, 15 Jun 2022 08:34:22 GMT

Hi Anonymous

You can use

DIVIDE ( TableName[Wholds], COUNTROWS ( 'VALUES ( "Date'[Date] ) ) )

Re: Average Calls per day, grouped by month

Anonymous — Fri, 17 Jun 2022 09:26:53 GMT

Hi Anonymous ,

Please check the formula.

Meaasure = VAR count_wholds = CALCULATE ( DISTINCTCOUNT ( 'Table'[Wholds] ), FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Activity Date].[Year] = SELECTEDVALUE ( 'calendar'[Date].[Year] ) && 'Table'[Activity Date].[Month] = SELECTEDVALUE ( 'calendar'[Date].[Month] ) ) ) RETURN count_wholds / COUNTROWS ( 'calendar' )

Best Regards,

Jay

Re: Average Calls per day, grouped by month

Anonymous — Fri, 17 Jun 2022 19:13:16 GMT

It did not work, I take it 'calendar' is the calendar table I have attached to the activity date.

Re: Average Calls per day, grouped by month

Anonymous — Fri, 17 Jun 2022 19:14:07 GMT

This worked if the columns in the matrix are from the Date/Calendar table used and not from the Date from the Datatable.