Forum Discussion
Arul
Super User
Super UserConvert 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])
amitchandakSuper User
Super UserArul , 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])
ArulSuper User
Super UserIt helps. Thank you