Forum Discussion

ROG's avatar
ROG
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

Week number wrong

Hey all,   I have a big problem! For where I work, the weeks start on a Monday, but as you can see below it's wrong. For the Wk32 it should show values from the 8th to14th. The columns Month, we...
Need Help
Show and Tell
Tips and Tricks
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi ROG ,

    According to your description, the week num of the year should starts at a weekday.

    Here's my solution, create a calculated column.

    Week Number =
WEEKNUM ( [Date], 2 )
    - IF ( WEEKDAY ( STARTOFYEAR ( 'Calendar'[Date] ), 2 ) IN { 6, 7 }, 1, 0 )

    Both the week number and week start date get correct result.

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi ROG ,

According to your description, the week num of the year should starts at a weekday.

Here's my solution, create a calculated column.

Week Number =
WEEKNUM ( [Date], 2 )
    - IF ( WEEKDAY ( STARTOFYEAR ( 'Calendar'[Date] ), 2 ) IN { 6, 7 }, 1, 0 )

Both the week number and week start date get correct result.

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.