摸索Tableau

将本年度第几周转变为对应范围内的某日期

201607 → 2016-02-18

DATEADD('day',7*(int(RIGHT([WEEK_ID],2))-1),DATEPARSE("yyyy-mm-dd",LEFT([WEEK_ID],4) + "-01-07"))

原文地址:https://www.cnblogs.com/ButterBall/p/6076670.html