Monthly Average of Each Day's Count

[Anonymous]

Hi, I'm having a dataset like this:

I want to calculate the average of each day's count. Since the count for the same is the same, I want each day's count be only calculated once.

Here is what I want:

Average = (100+200+300+400) / 31

Divided by 31 because there are 31 days in May.

Is it possible to achieve this by writing measures? 

Any help is appreciated.

[Anonymous]

I want to calculate the average of each day's count. Since the count for the same is the same, I want each day's count be only calculated once.

Here is what I want:

Average = (100+200+300+400) / 31

Divided by 31 because there are 31 days in May.

Is it possible to achieve this by writing measures? 

Any help is appreciated.

[ryan_mayu · Accepted solution]

@Anonymous 

you can try this

Measure = 
VAR _sum=SUMX(SUMMARIZE('Table','Table'[date],'Table'[count]),'Table'[count])
VAR _days=DATEDIFF(min('Table'[date]),EDATE(min('Table'[date]),1),DAY) 
RETURN _sum/_days

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[amitchandak · Accepted solution]

@Anonymous , Try one of the two

Averagex(summarize(Table,table[Date],"_1",[count]),[_1]) // Or use sum(Table[count])

Averagex(values(table[Date]),[count]) // Or use sum(Table[count])

[ryan_mayu · Accepted solution]

@Anonymous 

you can try this

Measure = 
VAR _sum=SUMX(SUMMARIZE('Table','Table'[date],'Table'[count]),'Table'[count])
VAR _days=DATEDIFF(min('Table'[date]),EDATE(min('Table'[date]),1),DAY) 
RETURN _sum/_days