How can I convert week into Date mm dd yyyy

Question

What I want?

Convert the week field into Date(mm/dd/yyyy).

Sample Dataset: Week 1 Week 2 Week 3 .........Week 22

What I did?

Dragged the date field into Columns and selected the week.

But I need to convert this into Date (mm/dd/yyyy).

Can someone tell me how can I achieve this?

Answer 1

Right click on your date field, you'll get a menu with the following options:

"Filter" , "Show quick filter", etc. You'll also see an option which says "Day.... May 8, 2011". That gives you a full date.

But if you want that date to have the "mm/dd/yyyy" format, you'll need to change it from the left pane. Right clicking on your date dimension provides the following option: "Default Properties/Date Format". You have a few default formats in there, including a custom formatting where you could make it mm/dd/yyyy.