Calendar table showing incorrect start of week

[Pricey79]

Hello you lovely people, I was hoping someone could help me please

I have a calendar table that shows week number (WeekNum) and start of week (SoWDate) , which I use in a visual. The issue I have is that for the 26 September its showing as week 39, where it should be week 38.

So its showing the visual like this, with week 39 as the 20 Sep, not the 27th as it should be:

Could anyone help please?

I hope I have given enough information. Thank you

[v-angzheng-msft · Accepted solution]

Hi, @Pricey79 

Do you mean you want to count the week every seven days instead of the calendar week starting from January 1st of each year?

Try to create a column with this:

week = 
var _r=RANKX(FILTER('Table','Table'[Year]=EARLIER('Table'[Year])),[Date],,ASC,Dense)
var _w=CEILING(_r,7)
return DIVIDE(_w,7)

result:

Please refer to the attachment below for details. Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pricey79]

@v-angzheng-msft 

Thank you very much

[amitchandak]

@Pricey79 ,

Try to create week number like

Week = weeknum([Date],2)

and check if that works fine

[Pricey79]

@amitchandak 

Thank you so much sir. That fixed the issue, although it states this week ( Week commencing 27 Sep 21) is week 40, whereas I beleve its week 39 of the calander? Is there a way to fix that please? 

Thank you for your time

[Pricey79]

@amitchandak 

I think its because its counting a few days as the end of december as week 1? Would you happen to know how I could fix that please?