How to show week number per month?

[cheid1977]

I need to show how much volume shipped the first, second, third, and fourth week of each month. How can you assign a number (1-4 or 5) to each week of the month?  Thanks.

[jkaluki254]

Did you ever get a solution for this, currently facing the same challenge........:(

[theov]

You can use mix of STARTOFMONTH and WEEKNUM to do that.

Here is a good video explaining it:

https://www.youtube.com/watch?v=Oq5WOmo94_Q

[ahmhekal]

I used this formula :

Week = (DAY('Calendar'[Date])+2.5) /7

[Anonymous]

i need add to my date hierarchy the number of month. i dont want show the name month( jan, feb, etc) 
, i want show the number month (1,2,3). Can you help me ?

---

---

[v-micsh-msft · Accepted solution]

Hi cheid1977,

Please take a try with the formula below in a calculated column:

weekinmonth = 1 + WEEKNUM ( 'Calenda'[Date] )-WEEKNUM( STARTOFMONTH ('Calenda'[Date]))

This formula would work with the month level, which should be no calculated errors.

Please reply back if you need any further assistance on this topic.

Regards

[kinui666]

Si tu semana empieza en LUNES, la fórmula quedaría así:

=1 + WEEKNUM(Calendario[Date];2)-WEEKNUM(STARTOFMONTH(Calendario[Date]);2)

[leahYan]

This is a good solution, but it only works if all the dates are unique.

In some cases, you would use a date column like invoiced date, start date, etc

 I hope this code would help:

Week Num =
 WEEKNUM ( 'Your table'[Your Date column] )-('Your table'[Your Date column].[MonthNo]-1)*4

[Anonymous]

Thanks for the response but I have a problem I get Weekmonth in some cases from 1 to 6 . I was Expecting 1to 5 but i get even more possible values. Any idea?

[efilipe]

This answer was very usefull to me! Thanks v-micsh-msft!

[Greg_Deckler]

OK, I didn't fully test this, but the general concept should work, you may have to tweak.

These are all columns:

WeekN = WEEKNUM([Date])

MonthN = MONTH([Date]) 

Column 9 = IF([MonthN] = 1,1,([MonthN]-1)*4)

Column 5 = IF([Column 9]=1,1,[WeekN] - [Column 9] - 1)

[Greg_Deckler]

Hard to say without your data or some sample data. I think the right way would be to add a custom column to your Date table.