How to create a calendar week so that the week runs from every Thursday to Wednesday?

[kathyyy19]

Hi Everyone,

I'd like to create a chart so that each column represents total sales from last Thursday to this Wednesday. For example, 1st column = Total sales from June 1st-7th, 2nd column = Total sales from June 8th-14th .... However, for last week of May, I'd like to show May24-May31 (Wednesday-Wednesday). Other columns being Thursday to Wednesday. Does anyone know how to do this?

Thank you in advance!

[amitchandak]

@kathyyy19 , refer to these blogs, to get a week start from any day

new columns

Week Start Wednesday = [Date] - weekday([Date],13)  + 1

Week end Wednesday = [Date] - weekday([Date],13)  + 7 // add 8 if needed

Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...
https://medium.com/chandakamit/cheat-sheet-any-weekdays-week-start-date-just-one-variable-apart-6b2e...