Forum Discussion
Continued Contributorweek 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
adityavighne , please find the calendar that start from any weekday
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
5 Replies
- amitchandak
Super User
adityavighne , please find the calendar that start from any weekday
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- adityavighne
FarhanAhmedCommunity Champion
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"
HI adityavighne ,
You can have a look at this blog.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
