Average Day Per Month

[sparkplug93751]

Hello, 

I have a data set that logs each time somebody signs in.

Everytime somebody signs in, a row is created ie if 15 people sign in then 15 rows are added.

I want to calculate the average number of rows per day for a month. ie if there's a total of 62 for the month of may, avg would be 2

Currently using:

if(hasonevalue(table1[monthend], calculate(averagex(values(table1[date],calculate(count(table1[names]),table1[occupation<>blank()),calculate(calculate(count(table1[names],table1[occupation]<>blank())

Any help is greatly appreciated. I think I'm overthinking this

[amitchandak · Accepted solution]

@sparkplug93751 ,

Assume your logic is correct

if(hasonevalue(table1[monthend], 
averagex(summarize(table1[date],"_1",calculate(count(table1[names]),not(isblank(table1[occupation])))),[_1])
,calculate(count(table1[names]),not(isblank(table1[occupation]))))