月的第x周 =
IF (
WEEKDAY ( 'D_Date'[Date] - DAY ( 'D_Date'[Date] ) + 1, 2 ) = 1,
WEEKNUM ( 'D_Date'[Date], 2 )
- WEEKNUM ( 'D_Date'[Date] - DAY ( 'D_Date'[Date] ) + 1, 2 ) + 1,
WEEKNUM ( 'D_Date'[Date], 2 )
- WEEKNUM ( 'D_Date'[Date] - DAY ( 'D_Date'[Date] ) + 1, 2 )
)

网友评论