Relative date filter - change most recent week

[Anonymous]

Hi all,

I created a report for which I would like to look at different time periods (YTD, latest 4 13 26 52, etc). I know this is achievable with bookmarks but then I have to re-filter each time I select a different date period and this is very inefficient. 

I discovered using a "relative date" slicer and this is very close to what I would like to do with one problem. The latest date always seems to be based on my computer date. I need this date to be based on the most recent date to which I have data.

For example: my current report only has information through week ending 8/25/18 but the relative date filter displays the day 9/8/18 because it is the latest full calendar week. If I want to look at the latest 34 weeks, I need to input 36 because I do not have data for the two weeks between 8/25 and 9/8.

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may try to set it in 'Date Range'. For example:

Regards,

Cherie