Forum Discussion
Post ProdigyWeek number reset for every month not working
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:
6 Replies
- Ritaf1983
Super User
Try to use :
WeekNum = ROUNDUP(DIVIDE(DAY('Calendar'[Date])-1, 7), 0)+1If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
prakash11440278Hi 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)+1Seems it works:If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- 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.
