DAX日期表 = ADDCOLUMNS (
CALENDAR ( DATE(2016,1,1),DATE(2017,12,31) ),
“年”, YEAR ( [DATE] )&“年”,
“季度”, ROUNDUP( MONTH ( [DATE] )/3,0 )&“季度”,
“月”, MONTH ( [DATE] )&“月”
)
DAX_日期函数创建表
最新推荐文章于 2024-04-10 09:31:54 发布
DAX日期表 = ADDCOLUMNS (
CALENDAR ( DATE(2016,1,1),DATE(2017,12,31) ),
“年”, YEAR ( [DATE] )&“年”,
“季度”, ROUNDUP( MONTH ( [DATE] )/3,0 )&“季度”,
“月”, MONTH ( [DATE] )&“月”
)