Forum Discussion

Icon for Continued Contributor rank

Continued Contributor

6 years ago

Solved

week start on Wednesday

Hi Team, I'm looking for weeknum should start on wednesday - tuesday WeekNUM don;t have options. so how to acieve this. regards, Aditya

amitchandak
6 years ago
adityavighne , please find the calendar that start from any weekday

https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482

How to get custom week of year

Start Year = STARTOFYEAR('Date'[Date],"3/31") // Give correct year end date
WeekDay = WEEKDAY([Date],2) //monday, Use Wed code from link
Start of Week = [Date] -[WeekDay]+1 //monday , Use Wed code from link
FY Year = YEAR('Date'[Start Year]) // use end year
FY Week = QUOTIENT(DATEDIFF(Minx(FILTER('Date',[FY Year]=EARLIER([FY Year])),'Date'[Start of Week]),[Date],DAY),7)+1

Icon for Community Champion rank

Community Champion

6 years ago

Hi adityavighne

One way to do it change the regional setting of your Windows to Start the Week from Wednesday

- Go to regional settings in windows

- Change the First Day of Week to "Wednesday"

- Use the Format instead of WeekNum to get the WeekNumber

WeekNum = FORMAT('Date'[Date],"WW")

- You will get the WeekNumber Starting from "Wednesday"