Tracking week over week improvement with dynamic dates

[ColinLang]

Hi All - 

My Company wants to track order accuracy week over week to see improvement of our manufacturing plants.  The plants are auditing on a cyclical basis and we want to see accuracy % 4 weeks prior to the cycle and week 1 through week 4 accuracy based off the selected cycle date.   Here is the desired output: 

So in the senario, the cycle start date is 2/5/2023, the 4 week baseline is accuarcy between 1/8/23 and 2/4/23. 
Week 1 accuracy would be 2/5/23 - 2/11/23
Week 2 accuracy would be 2/12/23 - 2/18/23
Week 3 accuracy would be 2/19/23 - 2/25/23
Week 4 accuracy would be 2/26/23 - 3/04/23

Right now, I just have the four seperate matrixs side by side and am manually changing the date fields for each.  Any help would be greatly appreciated! 🙂 

[ColinLang]

@Greg_Deckler  Here is a sample set of the data:

Date	Plant #	Products Audited	Issues found	Accuracy
2/24/2023	1	254	0	100.00%
2/24/2023	1	757	0	100.00%
2/24/2023	1	979	0	100.00%
2/24/2023	12	842	1	99.88%
2/24/2023	12	694	2	99.71%
2/24/2023	12	797	4	99.50%
2/24/2023	14	1652	13	99.21%
2/24/2023	14	639	0	100.00%
2/24/2023	14	1089	2	99.82%

The Goal would be to display five seperate accuracy measures ((products audited - issues found)/ products audited) by week off of the Date selected.   So in the example above if the Cycle date (dimensional Calendar table  date field) of 02/05/2023 was selected: 

the 4 week baseline is accuarcy ((products audited - issues found)/ products audited) for products audited between 1/8/23 and 2/4/23. 
Week 1 accuracy ((products audited - issues found)/ products audited) for products audited between 2/5/23 - 2/11/23
Week 2 accuracy ((products audited - issues found)/ products audited) for products audited between2/12/23 - 2/18/23
Week 3 accuracy ((products audited - issues found)/ products audited) for products audited between 2/19/23 - 2/25/23
Week 4 accuracy ((products audited - issues found)/ products audited) for products audited between 2/26/23 - 3/04/23

I have been trying to accomplish this using CALCULATE/FILTER/DATESBETWEEN  but haven't had any sucess. 

[Greg_Deckler]

@ColinLang Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...