Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
I'm looking for weeknum should start on wednesday - tuesday
WeekNUM don;t have options. so how to acieve this.
regards,
Aditya
Solved! Go to Solution.
@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
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)
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"
Proud to be a 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
I would use the below function
WEEKDAY([date],13)
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |