*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") )
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter