topic Re: Averaging Column by day, and then Summing those averages for the week in DAX Commands and Tips

Averaging Column by day, and then Summing those averages for the week

SSGUY — Tue, 17 Jan 2023 10:39:13 GMT

Trying to average a column for each day, but there are multiple rows for each date. I then need to sum these averages for the week based off a label. The label is "Winter Week 1", which continues through week 8.

I need to show on a graph the weekly sum on the Y axis, and the Week Name and Number on the X-Axis, basically with 8 numbers.

Attached is an example of my table

Re: Averaging Column by day, and then Summing those averages for the week

tamerj1 — Tue, 17 Jan 2023 10:57:20 GMT

Hi SSGUY
Please try

= SUMX ( VALUES ( 'Table'[Date] ), CALCULATE ( AVERAGE ( 'Table'[Value] ) ) )

Re: Averaging Column by day, and then Summing those averages for the week

SSGUY — Tue, 17 Jan 2023 11:05:43 GMT

Yes! Thanks you!