Forum Discussion
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...
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 , there is an issue reported for that.
For 2021, try like new week column like
Week Number =
if(Year([date] = 2021 && WEEKNUM([Date],2) >=2, WEEKNUM([Date],2) -1,WEEKNUM([Date],2))
Hi Amit,
And how would it work the previous and following years?
Many thanks.
Anonymous , You have to tell the logic, I can give that.
Also, vote for the issue.