week start on Wednesday

[adityavighne]

Hi Team,

I'm looking for weeknum should start on wednesday - tuesday

WeekNUM don;t have options. so how to acieve this.

regards,

Aditya

[harshnathani]

HI @adityavighne ,

You can have a look at this blog.

https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[FarhanAhmed]

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"

[amitchandak · Accepted solution]

@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-Powe...

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]

@amitchandak 

very well written blog.

Thanks for the solution.

[pranit828]

Hi @adityavighne 

I would use the below function

WEEKDAY([date],13)