7 Days a week from Monday

[UditJ]

I am using this formula to calculate 7 days a week = 

 = DIVIDE(CEILING(DAY('Calendar'[Date]),7),7)

Now what i want is to start the 7 days week calcualtion from monday. Below is what i have calcualted start day of week 

need to replace 1 , 2, 3,4, 5,6 and 7 by number 1 and so on.. as these days represent 1st week. Can this be done ? 

[v-xinruzhu-msft · Accepted solution]

Hi @UditJ 

You can create the following column

Column 2 =
VAR a =
    WEEKNUM ( [Date], 2 )
VAR b =
    WEEKNUM ( EOMONTH ( [Date], -1 ) + 1, 2 )
RETURN
    a - b + 1

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.