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

Anonymous

Not applicable

6 years ago

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-Power-BI-Turning/ba-p/1187482

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