How to calculate average per day

[bryan_d]

Hi Folks

I have the following data:

 

I am trying to calculate the average pages per day - i.e. average pages on a Thursday = xxxx

Have tried a few formulae but can't seem to hit the right one - any ideas?

Thanks

[mrsmhumphrey]

I'm looking for something similar but average per month

[Anonymous]

Hi @bryan_d,

   if you only want the average for one day the solution provided by @MattAllington is the best.

While if you are searching for the average for every day you can try this:

1) you can visualize the day column like a table (and sort it by the "DayOfWeek(no)" column)

2) after that you can create a measure with this formula:  averagePages = AVERAGE(yourTable[Pages])

3) and you obtain this:

Let me know if it works (and if it's what you were searching for).

#I'M Not An Expert#

[cmullor]

i tried something similar by day of week but it return the average if everything not that day of week =( help? please?

[MattAllington]

Try this

Average for Thursday = calculate(Average(TableName[Pages]),TableName[Day]="Thu")