Forum Discussion
jofoster
Microsoft Employee
Microsoft EmployeeDaily average across categories
Seems like this should be dead simple, but can't figure it out. My data set has multiple values per day. using the data set below, I want to be able to calculate the daily average by dayofweek or...
jdbuchanan71
Super User
Super UserHello jofoster
You just need to feed it the 3 rows you want it to average over like so:
Avg Interations = AVERAGEX ( VALUES ( 'Table'[EventTimestamp] ), CALCULATE( SUM ( 'Table'[Interactions] ) ) )
The VALUES ( 'Table'[EventTimestamp] ) returns a table that looks like this:
| Day 1 |
| Day 2 |
| Day 3 |
Then the sum of the interations is calculated for each row of that table and finally the average is calculated.