generate_445_calendar_m
Generate a retail 4-4-5, 4-5-4, or 5-4-4 calendar table as a new Power Query query, with one row per week including retail year, period, and week start/end dates.
Instructions
Generate a retail 4-4-5 / 4-5-4 / 5-4-4 calendar table as a new query, one row per week with RetailYear, PeriodOfYear, WeekOfPeriod, WeekOfYear, WeekIndex, WeekStart, WeekEnd. startDate is raw M, e.g. #date(2024,1,29). weeksPattern = 445 | 454 | 544. periodsPerYear = 12 (standard) or 13 (every period 4 weeks). Refresh afterwards.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | ||
| sessionId | Yes | ||
| startDate | Yes | retail year start date as raw M, e.g. #date(2024,1,29) | |
| weeksPattern | No | 445 | 454 | 544 | |
| periodsPerYear | No | 12 or 13 | |
| yearsToGenerate | No | number of retail years to generate (default 3) |