Create Week column starting from Tuesday and ending next Tuesday

[snamhoang]

Hi guys, 
I am trying to create a week column (displaying week number) which starts from Tuesday and ends next Tuesday.
Any suggestion?
I used Weeknum 21 but it starts from Mon, not Tue.

Thanks a lot

[Phil_Seamark · Accepted solution]

Hi @snamhoang

Please add this calculated column to your Calendar table

Week Starting Tuesday = 
var offset = switch(FORMAT('Dates'[Date],"DDD"),
    "Tue",0,
    "Wed",-1,
    "thu",-2,
    "Fri",-3,
    "Sat",-4,
    "Sun",-5,
    "Mon",-6
    ,0)
Return DATEADD('Dates'[Date],offset,DAY)

[GilbertQ]

Hi @snamhoang,

What I would do is to suggest creating a new column in the Query Editor.

In doing that you can easily create it in your Date table, and from there you could then create your weeks also based off your Week Number column?