Creating an average per week table

[Anonymous]

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.

[amitchandak · Accepted solution]

@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]))