Need Help with Averaging of Days and Summing of Weeks

[SSGUY]

Hey everyone. Having a lot of trouble with this issue, but relativley new to Power BI, so just looking for some help.

Just a few things I need to figure out:

1. I need to find the average of each day for a certain metric, but i have multiple rows of data for each day.

2. Once I have the averages for each day, i need to sum the averages for the week. The weeks are labeled in a different column, for example something like "Winter Week 1"

So basically i need all days averaged within the "Winter Week 1" and then I need to sum each average within those dates. 

Would love any help I can get here!

Thanks

Date                    Week Name and Number       Metric     

1-12-2023           Winter Week 1                        1000         

1-12-2023           Winter Week 1                        2000         

1-12-2023           Winter Week 1                        3000         

1-12-2023           Winter Week 1                        4000         

1-12-2023           Winter Week 1                        5000         

1-13-2023           Winter Week 1                        1000         

1-13-2023           Winter Week 1                        1000         

1-13-2023           Winter Week 1                        1000         

1-13-2023           Winter Week 1                        1000

1-13-2023           Winter Week 1                        1000

[jewel_at]

Hi @SSGUY 

You can try to create a new Dax table

Table 2 = 
SUMMARIZE('Table','Table'[Date],'Table'[Week],"Average", AVERAGE('Table'[Metric]))

To get the average per day, when using the Average column, select "Don't Summarize"

When you want to get the sum of the Average, then when you use the "Average" Column, select Sum. Make sure you add Week in your visual, so it aggregates by Week.

Hope that helps!

Jewel