Forum Discussion
Bratone
Helper I
Helper IIncorrect week number 2021/2022
Hello, I have a problem with the week number, in the transition from 2021 to 2022, I get this: For getting the week number I have followed this formula when adding a custom column, w...
Syndicate_Admin
Administrator
AdministratorOver return_type,
We usually use only 1 or 2 to indicate that the week starts on Sunday or Monday, but by default the system assumes that the first week will be the one that contains January 1, but the ISO 8601 calendar standard says that the first week of the year is the one that contains 4 days or more. If you must use a "21" as a return_type , anything you put dierente to 21 will go with the first system.
Week = WEEKNUM('Calendar Table'[Date],21)