DAX 自动生成日期表-与订单表(业绩表)相同日期区间

日期表 = ADDCOLUMNS (
CALENDAR (MIN('业绩表'[日期]), MAX('业绩表'[日期])), //关键在于MIN函数和MAX函数的使用
"年度", YEAR ( [Date] ),
"季度", "Q" & FORMAT ( [Date], "Q" ),
"月份", FORMAT ( [Date], "MM" ),
"日",FORMAT ( [Date], "DD" ),
"年度季度", FORMAT ( [Date], "YYYY" ) & "Q" & FORMAT ( [Date], "Q" ),
"年度月份", FORMAT ( [Date], "YYYY/MM" ),
"年/月/日", FORMAT ( [Date], "YYYY/m/d" ),
"星期几", WEEKDAY ( [Date],2 )
)