日期表 = ADDCOLUMNS(
CALENDAR(DATE(2023,1,1),DATE(2023,12,31)),
"年", YEAR ( [Date] ),
"季度", ROUNDUP(MONTH([Date])/3,0),
"月", MONTH([Date]),
"周", weeknum([Date]),
"年季度", year([date]) & "Q" & ROUNDUP(MONTH([Date])/3,0),
"年月", year([Date]) * 100 + MONTH([Date]),
"年周", year([Date]) * 100 + weeknum([Date]),
"星期几", WEEKDAY([Date])
)
计算每月实际天数
度量值 = CALCULATE(COUNTROWS('日期表'),ALL('日期表'),VALUES('日期表'[月]))
# 新建列=[度量值]