Hi, I have the following table structure. It has a week number, and number of hours for multiple (>100) people for each week. I need to create a measure that would show the running average of hours for each person for each week.
I would appreciate any suggestions.
Thank you!
| Week | Person | Hours |
| 1801 | Person A | 40 |
| 1801 | Person B | 42 |
| 1801 | Person C | 41 |
| 1802 | Person A | 43 |
| 1802 | Person B | 38 |
| 1802 | Person C | 40 |
Hi Rita,
This is best done in a PivotTable or Power Pivot PivotTable. Please see example attached.
Simply add the Hours field to the Values area twice. Set the second one to summarize using Average and then Show Values As > Running Total > by person.
Mynda
Hi Mynda,
Thank you for you reply.
Sorry, I somehow managed to leave out an important detail: I need the running average of the last 16 weeks.
Rita
Hi Rita,
Add the Week field to the Filters area of the PivotTable and filter the weeks you want the running average for.
Mynda
