Hi, I have a column called "WeekNumber" using the =WEEKNUM( [date] ) function, but it seems that there is a week number 53 for 2017 which appears in my slicers and graphs. The only date in week 53 is 31/12/2017.
Is there a way to fix this? Or go around this?
Do bear in mind that this column will also be used for the succeeding year (2018).
There is a 53 week in 2017 indeed. The point is how you want to deal with it. The solution could be simple like this:
1. If using this formula, the 1st week would have only 1 day.
Weeknum = WEEKNUM([Date],2)
2. Use a more specific formula then you can achieve anything you want.
Weeknum 2 = IF ( WEEKNUM ( [Date] ) = 53, 0, WEEKNUM ( [Date] ) )
So which one would you prefer?
Could you please mark the proper answer as solution?
Can you share a snapshot please? It's from 25/12/2017 in the snapshot of my last post.