Set today's week no (year starting from April) as max value in filter

[n3ptune]

Hello i have fin year 1/4-31/3 and i want to have a filter with between slider for week no.

I want to set the max value of the slider to be the today's week No.

[amitchandak]

@n3ptune , You have to create a column like this 

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

or

new column =

var _date = max(Table[Date])

return

Switch( True(),
[start week]<=_date && [end date]>=_date ,"This Week" ,
[Week Name]
)

for week start and end refer

https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...