Forum Discussion

prakash11440278's avatar
prakash11440278
Icon for Post Prodigy rankPost Prodigy
3 years ago

Week 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 ...
Need Help
Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

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's avatar
prakash11440278
Icon for Post Prodigy rankPost Prodigy
3 years ago

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