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?:

 

DayDateISO8601

Special

Thursday31.12.20205353
Friday01.01.2021531
Saturday02.01.2021531
Sunday03.01.2021531
Monday04.01.202111
Tuesday05.01.202111
Wednesday06.01.202111
Thursday07.01.202111
Friday08.01.202111
Saturday09.01.202111
Sunday10.01.202111
Monday11.01.202122

 

Looking forward to your answers.

 

Thanks.

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.

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Amit,

       

      And how would it work the previous and following years?

       

      Many thanks.

      • amitchandak's avatar
        amitchandak
        Super User
        5 years ago

        Anonymous , You have to tell the logic, I can give that.

        Also, vote for the issue.

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