若要新增Calendar Table 在 Power BI 上的話,可以參考以下DAX:
DIM_Calendar =
var __MaxDate = DATE(2023,12,31)
var __calendar=
ADDCOLUMNS (
CALENDAR (DATE(2019,1,1), __MaxDate),
“DateKey”, YEAR([Date]) & RIGHT(“00”&MONTH([Date]),2) & RIGHT(“00”&DAY([Date]),2),
“Year”, YEAR([Date]),
“Quarter”, “Q” & ROUNDUP (MONTH([Date])/3,0),
“Month”, FORMAT([Date],”MMM”),
“Month2”, RIGHT(“00”& MONTH([Date]),2),
“Day”, Day([Date]),
“YearQuarter”, YEAR([Date]) & “Q” & ROUNDUP (MONTH([Date])/3,0),
“YearMonth”, YEAR([Date]) & RIGHT(“00”& MONTH([Date]),2)
)
return __calendar