BCI Calendar ISO

[Dsilberman]

Dsilberman

I have a bciCalendar that is looking at utlitization percentages accross the board. I'm trying to set it the weeks by ISO-week numbering so that the first week of 2021 starts on 1/3/21. The issue that I'm running into is that the visual is creating two separate weeks 53 and having week 1 start on 1/10.
​[4:30 PM] Joaquin Zuniga Cardenas

Here is the formula I used to create a 'Date' table [

Date = ADDCOLUMNS(

CALENDAR("2020,01,01","2021,12,31"),

"Year",YEAR([Date]),

"MonthYearNum",CONCATENATE(YEAR([Date]),FORMAT([Date]," MMM")),

"MonthNum",MONTH([Date]),

"Month",FORMAT([Date],"MMMM"),

"Day",FORMAT([Date],"DD"),

"WeekNum",FORMAT(WEEKNUM([Date]+1,21),"00"),

"Week",CONCATENATE("Week",FORMAT(WEEKNUM([Date]+1,21),"00")

))

]. Even on here in the table it has the right labels for the weeks and dates.