*DateTable = VAR MinDate = MIN(OE_INV_SNAPSHOTS[Actual_Snapshot_Date]) VAR MaxDate = MAX(OE_INV_SNAPSHOTS[Actual_Snapshot_Date]) RETURN ADDCOLUMNS ( CALENDAR ( MinDate, MaxDate ), "Year", YEAR([Date]), "Month", MONTH([Date]), "Day", DAY([Date]), "Quarter", QUARTER([Date]), "MonthName", FORMAT([Date], "MMMM"), "Weekday", WEEKDAY([Date], 2), "WeekdayName", FORMAT([Date], "dddd"), "YearMonth", FORMAT([Date], "YYYY-MM") )