Goal: Create a contiguous Date Table.
CALENDAR: You pick Start/End.
CALENDARAUTO: Scans your data model for min/max dates.
Source: Sales Table (Data Model)
Result: New Date Table
Ready...
💻 DAX Formula
-- Scenario 1: Manual Range
TABLE Dates =
CALENDAR (
DATE(2023, 1, 1), -- Start Date
DATE(2023, 1, 3) -- End Date
)
-- Scenario 2: Automatic Scan
TABLE Dates =
CALENDARAUTO( )
-- Scans entire model for Min/Max dates.