cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Week 53 appearing in 2017

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).

 

Week Number 53.JPG

 

Thanks!

5 REPLIES 5
Highlighted
Microsoft
Microsoft

Re: Week 53 appearing in 2017

Hi @afk,

 

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] ) )

Week_53_appearing_in_2017

 

So which one would you prefer?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Microsoft
Microsoft

Re: Week 53 appearing in 2017

Hi @afk,


Could you please mark the proper answer as solution?

 

Best Regards!
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper II
Helper II

Re: Week 53 appearing in 2017

Hi @v-jiascu-msft

 

Many thanks for your suggestions! Is there a way to start Week 1 on 02/01/2017?

 

When I tried the first suggestion, I had week 53 starting on 26/12/2017.

 

AFK

Highlighted
Microsoft
Microsoft

Re: Week 53 appearing in 2017

Hi @afk,

 

Can you share a snapshot please? It's from 25/12/2017 in the snapshot of my last post.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper II
Helper II

Re: Week 53 appearing in 2017

Hi @v-jiascu-msft,

 

Yes you're right, it is also 25/12/2017 for me. 

 

Is there a way to start week 1 on 02/01/2017? Such that week 52 is 25/12/2017 - 31/12/2017?

 

AFK

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors