用DAX公式直接创建日期表.txt

立即下载 作者: 听风～
上传时间: 2024-04-19
关键词: Date YEAR ONTH DUP ROUN 3,0 100 WEEKNUM date
大小 441 B
描述
鏃ユ湡琛� = ADDCOLUMNS ( CALENDAR ( date(2016,1,1),date(2017,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]))
目录
Date/YEAR/ONTH/DUP/ROUN/3,0/100/WEEKNUM/date/ Date/YEAR/ONTH/DUP/ROUN/3,0/100/WEEKNUM/date/