Forum Discussion
Solved
Convert Week number into date
Hi All,
How can I convert week no into date ?
So that I can use that in continuous X-Axis of my visual.
Thanks,
Arul
Arul , Assume you have Year and week no with you
New column =
var _st = date([Year],1,1)
var _st_week = _st - weekday(_st ,2) +1 //monday week
return
_st_week + (7 *[week no])
2 Replies
Arul , Assume you have Year and week no with you
New column =
var _st = date([Year],1,1)
var _st_week = _st - weekday(_st ,2) +1 //monday week
return
_st_week + (7 *[week no])
It helps. Thank you
