Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Week number

Hi all,   How can I achieve the following week number results?:   Day Date ISO8601 Special Thursday 31.12.2020 53 53 Friday 01.01.2021 53 1 Saturday 02.01.2021 53 1 S...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    You can create the calculated column like this:

    ISO8601 = WEEKNUM('Table'[Date],21)

    Please refer the [ISO] column in my sample file from the previous post.

     

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

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi Anonymous ,

Based on your description, seems like you want to define 10 days as a week for each year, you can create a calculated column like this:

Special =
ROUNDUP (
    DIVIDE (
        DATEDIFF ( STARTOFYEAR ( 'Table'[Date].[Date] ), 'Table'[Date], DAY ) + 1,
        10
    ),
    0
)

Attached a sample file in the below, hopes to help you.

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello,

     

    Thank you for that.

     

    How can I get the week numbers to calculate based on the ISO8601?:

     

    DayDateWeek Number ISO8601
    Thursday31.12.202053
    Friday01.01.202153
    Saturday02.01.202153
    Sunday03.01.202153
    Monday04.01.20211
    Tuesday05.01.20211
    Wednesday06.01.20211
    Thursday07.01.20211
    Friday08.01.20211
    Saturday09.01.20211
    Sunday10.01.20211
    Monday11.01.20212

     

    Looking forward to hearing back from you.

     

    Best regards.

    • v-yingjl's avatar
      v-yingjl
      Community Support
      5 years ago

      Hi Anonymous ,

      You can create the calculated column like this:

      ISO8601 = WEEKNUM('Table'[Date],21)

      Please refer the [ISO] column in my sample file from the previous post.

       

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