Forum Discussion
Creating an average per week table
Hi All,
I have a data set that looks something like this:
| Date | Result |
| 16/11/2020 | 5 |
| 18/11/2020 | 7 |
| 18/11/2020 | 2 |
| 19/11/2020 | 8 |
| 22/11/2020 | 1 |
| 24/11/2020 | 9 |
| 27/11/2020 | 4 |
| 28/11/2020 | 3 |
I would like to generate a new table so that one column is the week start date (Monday) and the other is the average result of that particular week (Mon-Sun).
So if you were to take the above as an example, I should have something like this:
| Week Start Date | Average Result of Week |
| 16/11/2020 | 4.6 |
| 23/11/2020 | 5.3 |
Any help would be fully appreciated. Thanks.
Anonymous ,Create a new column like
Week Start date = 'Table'[Date]+-1*WEEKDAY('Table'[Date],2)+1
Now you can use thismeasure in the visual
measure = Average('Table'[Result])
or create a table like
new table = summarize('Table','Table'[Week Start date] ,"Avg", Average('Table'[Result]))
1 Reply
Anonymous ,Create a new column like
Week Start date = 'Table'[Date]+-1*WEEKDAY('Table'[Date],2)+1
Now you can use thismeasure in the visual
measure = Average('Table'[Result])
or create a table like
new table = summarize('Table','Table'[Week Start date] ,"Avg", Average('Table'[Result]))