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

     

     

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

 

 

fabiolamelo's avatar
fabiolamelo
Helper II
5 years ago

Thanks, CNENFRNL  your solution works 🙂