Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Kayfynn
Frequent Visitor

Start date of week

i Have this DAX for week of month

Week of Month =
   var week_of_year = WEEKNUM('Calendar Table'[Date])
   var start_of_month = STARTOFMONTH('Calendar Table'[Date])
   var week_of_start_of_month = WEEKNUM(start_of_month)
   var weekofmonth = (week_of_year - week_of_start_of_month) + 1
   return
   weekofmonth
 
i want the start date of each of the week. For example the 1st of march 2023 is no a wednesday.  my week of month function counts the first week of march from 1st march to 4th march which is saturday (this is exactly how i want it). My problem is my start date of week funtion picks 27th Febuary which is the monday of that week instead of the wednesday which is the start of the month. 
This is the start of week function i used
Start of Week =
   var week_of_year = WEEKNUM('Calendar Table'[Date])
   var start_of_month = STARTOFMONTH('Calendar Table'[Date])
   var week_of_start_of_month = WEEKNUM(start_of_month)
   var weekofmonth = (week_of_year - week_of_start_of_month) + 1
   var start_of_week1 = start_of_month - WEEKDAY(start_of_month,2) + 1
   var start_of_week = start_of_week1 + (weekofmonth - 1) * 7
   return start_of_week
Can someone help me resolve my problem
1 REPLY 1
amitchandak
Super User
Super User

@Kayfynn , these blog can give week start date on any day of week

Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...
https://medium.com/chandakamit/cheat-sheet-any-weekdays-week-start-date-just-one-variable-apart-6b2e...

 

 

The week that reset based on year

Week That Resets Yearly
https://community.powerbi.com/t5/Community-Blog/Week-That-Resets-Yearly-Decoding-Date-and-Calendar-3...

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.