(1) Adding Fiscal Week to Calendar table; (2) Modifying Calendar Start Month

Hi Anonymous ,

If I understand correctly, the issue is that you want to add week to the calendar and modify the start dates. Please try the following methods and check if they can solve your problem:

1.Add a new column to the table.

Calendar = 
ADDCOLUMNS(
    CALENDAR(DATE(2022,1,31), DATE(2024,12,31)),
    "Year", YEAR([Date]),
    "Week", WEEKNUM([Date], 2)
)

2.Modify the start month.

Calendar = 
ADDCOLUMNS(
    CALENDAR(DATE(YEAR(TODAY()) - 1, 7, 1), DATE(YEAR(TODAY()), 6, 30)),
    "Year", YEAR([Date]),
    "Week", WEEKNUM([Date], 2)
)

Best Regards,

Wisdom Wu