Power BI DAX: DAX生成日历表

DAX公式如下： 

PBI Date = 
VAR StartYear = YEAR(NOW())-5
VAR EndYear = YEAR(NOW())+5
RETURN
ADDCOLUMNS (
    CALENDAR (DATE(StartYear,1,1), DATE(EndYear,12,31)),
    "Year", YEAR ([Date]),
    "Date_Key",value(FORMAT([Date], "YYYYMMDD")),
    "Month", MONTH([Date]),
    "Month Name",FORMAT([Date],"MMMM"),
    "Day",DAY([Date]),
    "Year Month", VALUE(FORMAT([Date], "YYYYMM")),
    "Week", WEEKDAY ([Date],2),
    "Month Abbr",FORMAT([Date],"MMM"),
    "Weekday Abbr",FORMAT([Date],"DDD"),
    "Quarter",QUARTER([Date]),
    "Quarter Name","Q" & CONVERT(QUARTER([Date]),STRING)
)

部分数据展示，生成的是前后5年的日历：