Forum Discussion
CornelisV
Helper IV
1 year agoCreate an calendar table with only Year - Week numbers
Dear all, Could you please demonstrate me how to create an alternaticv Calender table with only Year and Week numbers: So... Year Weeknumber 2024 51 2024 52 2025 01 2025 02 2025...
- 1 year ago
CornelisV Try this:
Calendar Table = VAR __BaseTable = CALENDAR( DATE( 2024, 1, 1), DATE( 2025, 12, 31 ) ) VAR __Table = ADDCOLUMNS( __BaseTable, "Year", YEAR( [Date] ), "WeekNumber", WEEKNUM( [Date] ) ) VAR __Result = DISTINCT( SELECTCOLUMNS( __Table, "Year", [Year], "Weeknumber", [WeekNumber] ) ) RETURN __Result