Assuming you have a proper Date dimension, you could do this as a calculated column in that table. Basically, group all of the rows for each month together, and then subtract the weekNumberOfYear for the first week of the month from the current
row's weekNumberOfYear. Then add 1 so that week 1 is 1 and not 0.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.