Forum Discussion
(1) Adding Fiscal Week to Calendar table; (2) Modifying Calendar Start Month
Hello. 1) I got this Dax to create a Calendar table: Calendar = ADDCOLUMNS(CALENDAR(DATE(2022,1,31),DATE(2024,12,31)),"Year",YEAR([Date])) Question: How do I add "Week" to the Calendar? 2) No...
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
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