Learn how to convert a column type from TEXT data type to DATE data type.

Step 1
Click the "Order Date" column in the preview window

Step 2
Select "Transform or convert this field"

Step 3
Click Add and Select "Convert to DATE datatype"

Step 4
Click the Arrow button and Select the appropriate date parts

Step 5
When you're done, click the Modify button to set the month names appropriately

Step 6
Click OK when you're done

Step 7
Click OK

Step 8
Check if the data is converted as expected

Step 9
You can now use the new converted column in your dimensions.