KB204546: How to determine the Week No. of a given date in that month if Monday is considered as the first day of a week in MicroStrategy Analytics Developer 10.x

Strategy provides a “Week” function that returns the number of the week in the year of the input date. When using this function, Sunday is considered as the first day of a week by default. There might be some circumstance that needs to calculate the number of the week in the month of the input date, and requires Monday is the first day of a week.
Follow the steps below to achieve the requirement:
1. Create a metric as below:

Case((DayOfWeek(MonthStartDate(Day)) = 1), (Ceiling(((DayOfMonth(Day) - 1) / 7)) + 1), Ceiling((((DayOfMonth(Day) + DayOfWeek(MonthStartDate(Day))) - 2) / 7)))

]