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.

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.