PowerBI Visual with slicer - Averages

Hi,

I'm not sure how to approach this problem. I have two tables, a Date table and a Data Table, both are at the end of the question.

I want to create a visualisation with options for:
1. A Date Slicer Start Date (DD/MM/YYYY) - End Date (DD/MM/YYYY)
2. Calculated Value1 - Average of the weekly average weight per carton (7 day) average over date Slicer time period
3. Calculated Value2 - Average of weight per carton over the entire Slicer time period

Formula from Excel:
1. SUM of Weight = (PACK WGHT + JCE WGHT1)
2. Average Carton Weight = SUM of Weight/CARTON QTY

Example 1:
Date Splicer - 01/10/2022 - 10/10/2022 (10 days)
Two values:
1.  Average of Weekly Average Weight per Carton of 1 week (7 days from 3/10 - 10/10/2022)

2. 10 day Average of Weight per Carton

Example 2:
Date Splicer 07/08/2022 - 10/10/2022 (64 days)
1. Carton Weight Average of last 9 weeks (truncate from 9 weeks 1 day) average weight ((average of every 7 days from 08/08 to 10/10/2022)/9 weeks)

2. 64 day Average of Weight per Carton

The Date and Data tables are below

Data Table

Date Table

Thanks in advance