*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")
)
Comments