Forum Discussion
Average for week
Hello, I am trying to create a column that will find the average weekly sum, from Monday thru Sunday. For example, for every [Date] record that contains Feb 1, it would show the average of all [...
Thank you for your response.
I have added a column to my table CalendarTable:
Week Start date(Mon-Sun) = CalendarTable[Date]+-1*WEEKDAY(CalendarTable[Date],2)+1
The column appears to show the ideal outcome.
With that said, when I create my measure:
Measure = AVERAGEX(Values(CalendarTable[Week Start date(Mon-Sun)]), CALCULATE(SUM('Daily Force Report'[Total - Total_])))
and use it in a visualization, it returns the same values as 'Daily Force Report'[Total - Total_)
Can you tell if I'm doing something wrong? As far as relationships, I currently have CalendarTable[Date] pointing one way toward 'Daily Force Report'[Date]. I tried setting it to both, but it made no difference.