2 of 2 people found this helpful
To do this, I'd recommend making a custom date based on week, then right click on this new field and update the default properties to be the format that you want.
Then use this field and make it into a date hierarchy with month as a custom date too.
Pratik sorry, I can't do that, as our data are confidential and too complex to randomize quickly.
Mavis, do you mean as in creating a calculated field with DATEPART week another one with month? I'm stumbling my way around that, I'll see if it works, thank you ))
Okay it worked through STR('Week '+DATENAME('week',[Date])) as a calculated field being put into a hierarchy of other Datename functions.
Thank you very much!