Forum Discussion

amirghaderi's avatar
amirghaderi
Helper IV
4 years ago
Solved

Rolling Date (full week) Filter

I have chart which filter the scale from 30 days ago to 150 days in future. There is a column which define this scale and has been assigned as the filter to the chart. I want to have this filter to b...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi amirghaderi 

     

    Assume your week starts on Monday and ends on Sunday, you can use the following column formula.  

    Rolling Month =
IF (
    AND (
        'Date'[Date] > TODAY () - WEEKDAY ( TODAY (), 2 ) - 28,
        'Date'[Date] < TODAY () - WEEKDAY ( TODAY (), 2 ) + 140 + 1
    ),
    "Include",
    "Exclude"
)

     

    TODAY () - WEEKDAY ( TODAY (), 2 ) will return the date of last week's Sunday. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

     

     

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi amirghaderi 

 

Assume your week starts on Monday and ends on Sunday, you can use the following column formula.  

Rolling Month =
IF (
    AND (
        'Date'[Date] > TODAY () - WEEKDAY ( TODAY (), 2 ) - 28,
        'Date'[Date] < TODAY () - WEEKDAY ( TODAY (), 2 ) + 140 + 1
    ),
    "Include",
    "Exclude"
)

 

TODAY () - WEEKDAY ( TODAY (), 2 ) will return the date of last week's Sunday. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.