Date Table

PHOTO EMBED

Wed Jul 24 2024 18:35:54 GMT+0000 (Coordinated Universal Time)

Saved by @bdusenberry

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