Slicer used to select end date for rolling 12 weeks

[Anonymous]

Hey guys,

I'm trying to use a slicer so that when I select a week (say week 50), the data in a graph shows everything for the last 12 weeks ending on week 50. I can't use the relative slicer function because I need the slicer to be in the select individual weeks format. Thanks

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

Please check out the demo in the attachment.

1. Create a new date table. Because the dates will be filter out by the slicer which is from the same table. 

2. Don't create any relationship with other table. 

3. Modify the measure below.

Measure 2 =
VAR minDate =
    FIRSTDATE ( DATESINPERIOD ( 'Table1'[Date], MAX ( 'Table1'[Date] ), -84, DAY ) )
RETURN
    IF (
        MIN ( 'Table 2'[Date] ) < minDate
            || MIN ( 'Table 2'[Date] ) > MAX ( 'Table1'[Date] ),
        BLANK (),
        SUM ( 'Table 2'[Value] )
    )

Best Regards,

Dale