I am having week number column which is part of date dimension as 1,2,…. 52.
Now my requirement is to add WK as prefix before weeknumber.
Week : 1, 2, 3, …. 52 and i am looking for Week: WK01,WK02…..WK52.
Could you please suggest on the above requirement.