Need Help Finding a way to slice based on last 4 weeks etc

[UKFan14]

Hi There,

I have a column called "Fiscal Week Start" in week increments. 

I have another column called "Actual Sales".

I want to somehow have a slicer that will look at the "Fiscal Week Start" column and take the most recent date/row that
has a total > than 0 in the "Actual Sales" column. I want to do this for the latest Week, 4 Weeks, 12 weeks and 52 weeks.

So for instance the slicer would say L52, L24, L12, L4 , LW... 

LW would only show 7/23/2023 sales, L4 would only show sales for the data in the rows with dates 7/23, 7/16, 7/09, 7/02
Power BI Time Period Help.xlsx

Thanks!

[mickey64]

For your reference.

Step 1: I made a parameter table 'Week List'.

Step 2: I made a calendar table.

Step 3: I made a relastionship.

Step 4: I made some measures.

M_Select Week = SELECTEDVALUE('Week List'[Days])

M_LASTDATE = LASTDATE(ALL('Sheet1'[Fiscal Week Start_2]))

M_FIRSTDATE = [M_LASTDATE]-[M_Select Week]

M_Sum Selected Week = CALCULATE(SUM(Sheet1[Actual Sales]),DATESBETWEEN('Calendar'[Date],[M_FIRSTDATE],[M_LASTDATE]))

Step 5: I made a slicer.

[mickey64]

Sorry.

I added a column below... 

Fiscal Week Start_2 = IF([Actual Sales]>0,[Fiscal Week Start])

[mickey64]

I made a measure and 2 columns.

[UKFan14]

Thanks for trying to help out!

Unfortunately, I would need only the dates that had above a 0 in the "actual sales column". At least the way I have the formula, It is just taking the latest date in my table.

Also, I am trying to get a slicer that doesnt take 4 weeks ago, but the last 4 weeks in summation/aggregate.

So L4 would not just be June 8th 2024 in the below example, but the 3 weeks above it as well.

THank you