Same Period Last week in Slicer By default

[PPPBI]

Hi,

In one of my report I wanted to create the slicer that should always have default selection of latest date and offset it to 7 days.

Ex: If I am selecting 20-Feb 2023 in slicer then the graph should show the data for 20-Feb 2023 and 13-Feb 2023 (only 2 days of data), if 17-Feb 2023 is selected the it should data for 17-Feb 2023 and 10-Feb 2023 only. (excluding Saturday and Sundays)

Also it would be great if same slicer has "Custom Date" selection option.

Table Name [Sheet1]

Date Field Name [ Status Date]

Value Filed Name [Sales]

Thanks.

[amitchandak]

@PPPBI , if you want select a week and want to show more than that, You need have slicer in independent date table

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Rank])
var _min = _max -1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Rank] >=_min && 'Date'[Rank] <=_max))

Where Week rank is column in both date tables

Week Rank = RANKX('Date','Date'[Week Start date],,ASC,Dense)
OR
Week Rank = RANKX('Date','Date'[Year Week],,ASC,Dense) //YYYYWW format

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI