Week range filter

[fabiolamelo]

Hi everyone,

I created a filter with a week number that works fine. "Weekday number", WEEKNUM( [Date] ),

However, I need to inform the range of the week, for example: 

Today is 15/11/2020
I would like to show in the filter 
W46 - 09/11 to 15/11

For the next weeks
W47 - 16/11 to 22/11.
W48 - 23/11 to 29/11

How can I do that? I tried to find something similar like this on the community but I couldn`t.
Can you please help me?
Thanks.

[CNENFRNL · Accepted solution]

Hi, @fabiolamelo , you might want to try this pattern,

Week Selected = 
VAR __day_selected =
    MAXX ( ALLSELECTED ( 'Calendar'[Date] ), 'Calendar'[Date] )
VAR __start_of_week =
    __day_selected - WEEKDAY ( __day_selected, 2 ) + 1
VAR __week_selected =
    DATESINPERIOD ( 'Calendar'[Date], __start_of_week, 7, DAY )
RETURN
    MINX ( __week_selected, 'Calendar'[Date] ) & " to " & MAXX ( __week_selected, 'Calendar'[Date] )

///////////////////////////
Next Week = CALCULATE( [Week Selected], DATEADD('Calendar'[Date], 7, DAY) )

//////////////////////////
Next 2 Week = CALCULATE( [Week Selected], DATEADD('Calendar'[Date], 14, DAY) )

[fabiolamelo]

Thanks, @CNENFRNL  your solution works 🙂