Change The Relative Date to Tuesday from Sunday in Power BI/Query

[sid-poly]

There is a Table with a column date in it. There is another calendar table as well which provides the dates for the specific range.

During the Visualisation when we use the realtive date filter. It shows possible options of in this week, preivous, next week. Current problem to solve is to change the realtive date filter to "Is in this" > Week where the week starts from "Tuesday" and not "Sunday/Monday".

How can this be achieved?

[BA_Pete]

Hi @sid-poly ,

I don't think there's any way to change this within the native relative date slice.

I would suggest that you add a new column in your calendar table, something like this:

let todayDate = Date.From(DateTime.LocalNow()) in
if todayDate >= Date.StartOfWeek(Date.AddDays(todayDate, - 7), Day.Tuesday)
    and todayDate <= Date.EndOfWeek(Date.AddDays(todayDate, - 7), Day.Tuesday)
then "Last Week" 
else if todayDate >= Date.StartOfWeek(todayDate, Day.Tuesday)
    and todayDate <= Date.EndOfWeek(todayDate, Day.Tuesday)
then "This Week"
else if todayDate >= Date.StartOfWeek(Date.AddDays(todayDate, + 7), Day.Tuesday)
    and todayDate <= Date.EndOfWeek(Date.AddDays(todayDate, + 7), Day.Tuesday)
then "Next Week"
else null

Pete