Calculate Start week always from 1st day of month

[Uzi2019]

Hi experts,

I want to calculate start week and end week but there is condition I have attached a screen shot.( Week should always be start from 1st day of the month )

I want to calculate 3 different measure "Start week", "End week" and "No of days".

I want above mentioned result.

Please guys I need it on urgent basis. Any help would be appreciated.

Thank You in Advance.

[amitchandak · Accepted solution]

@Uzi2019 , You can get the start or week like

Start Month = STARTOMONTH('Date'[Date])
Month Week Start = [Start Month] + QUOTIENT(datediff([Start Month],[date],day),7) *7

[Uzi2019]

@amitchandak  Thank you so much Start week is working now. 

Could you please also share the EndWeek like I mentioned in Screen shot.

[amitchandak]

@Uzi2019 , Try like

Month Week end = if( [Month Week Start]+7 <= eomonth([Month Week Start] ,0),[Month Week Start]+7 ,eomonth([Month Week Start] ,0))

[Uzi2019]

@amitchandak ,

Start Week = STARTOFMONTH(TableDate]) + QUOTIENT(DATEDIFF(STARTOFMONTH(Table[Date]),Table[Date],DAY),7)*7

End Week = IF(Table[Start Week]+6<=EOMONTH(Table[Start Week],0),Table[Start Week]+6,EOMONTH(Table[Start Week],0))

I just did minor changes in End Week Column suggested by. i.e. replace 7 with 6 so now its properly ending with 7th of Month as End week.

Thanks a bunch for your quick response and workable solution.