Set Week slicer default to previous week

[oriabbhou1]

Hi,

I have 3 columns from my site table.

Week= 'Survey_20_21'[Week Start Date].[Date]&"-" & 'Survey_20_21'[Week End Date].[Date]

Week start date= Survey_20_21[Distro Date].[Date] - WEEKDAY('Survey_20_21'[Distro Date].[Date],2)

Week end date= 'Survey_20_21'[Distro Date].[Date] - WEEKDAY('Survey_20_21'[Distro Date].[Date],2) + 7

I have set week to a slicer so my user can view my report by their desired week but now I need help defaulting my week slicer to the previous week. Any help would be greatly appreciated.

[amitchandak]

@oriabbhou1 , Create a Column like this in your date table and sort it on Week Start date and then you can select Last week in The slicer

Week Type = Switch( True(),
[start week]<=Today() && [end date]>=Today(),"This Week" ,
[start week]<=Today()-7 && [end date]>=Today()-7,"Last Week" ,
[Week Name]
)