cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## 7 Days a week from Monday

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 ?

1 ACCEPTED SOLUTION
Community Support

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.

Community Support

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.