Forum Discussion
BCI Calendar ISO
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.
No RepliesBe the first to reply