Forum Discussion

fabiolamelo's avatar
fabiolamelo
Helper II
5 years ago
Solved

Week range filter

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.

Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    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) )

     

     

2 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion
    5 years ago

    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) )