PowerBI创建基础的日期表

PowerBI内，新建表，的方法来创建日期表。

效果： 

 

 TODAY()，是因为结合自身的业务需求，规律的新增日期。

代码：

Date_table = ADDCOLUMNS (
CALENDAR ( date(2022,10,10),TODAY()),
"年", 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])
)