Week number reset for every month not working

[prakash11440278]

Hi PBI Experts,

I am not able to get the week number reset for every month. My week will start on monday for every week. I tried the below dax expression it is giving fine for those months having 4 weeks in it, but if we have 5 weeks the first week number is showing as "W0". Please help.

Dax Expression:

Week of Month =

var currentweek=WEEKNUM([Date],2)

var startWeek=WEEKNUM(DATE([Year],[Month],1),2)

return

"W" & Currentweek-startWeek

[Ahmedx]

pls try this

[prakash11440278]

Hi @Ahmedx , Thanks for your reply.

My week always start on monday and end on sunday that week we can call as "W1". If apart from monday any dates will be consider for the previous month weeks. Below is the screen shot for your reference.

[Ritaf1983]

Hi @prakash11440278 

Try to use :

WeekNum = ROUNDUP(DIVIDE(DAY('Calendar'[Date])-1, 7), 0)+1

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

[prakash11440278]

Hi @Ritaf1983 , Thanks for your reply.

I tried the expression. It is not giving the requred result. March month is starting with week number 2 & May month starting first day as 1 remaining 2 is coming. PFB screen shots. 

[Ritaf1983]

This is because first monday in march is 06/03.

Try to modify it for :

Week = WEEKNUM('Calendar'[Date],2)-WEEKNUM(EOMONTH('Calendar'[Date],-1)+1,2)+1

Seems it works:

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

[prakash11440278]

Hi @Ritaf1983 , Thanks a lot for your quick reply.

I tried the expression below are the results. Seems i am not getting correct data.

Considering the April 23 month. Week start on monday and end on sunday.

April 3rd to 9, should display as week 1