Power BI 年历矩阵

日期表 = 
ADDCOLUMNS(CALENDAR(DATE(2026,1,1),DATE(2026,12,31)),
    "年",YEAR([Date]),
    "月",MONTH([Date]),
    "日",DAY([Date]),
    "星期",RIGHT(FORMAT([Date],"AAA"),1),
    "星期值",WEEKDAY([Date],2),
    "第几周",WEEKNUM([Date],2) 
)

SVG.年历 = 
"data:image/svg+xml;utf8,<svg xmlns='http://www.w3.org/2000/svg' width='100' height='100'>
    <circle cx='50' cy='50' r='40' fill='deepskyblue' fill-opacity='" &
        IF(SELECTEDVALUE('日期表'[Date])<=today(),1,0.2) & "'
    />
</svg>"