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

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

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'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