Resolution
Create calculated fields to convert the date formats into recognizable formats.
Option 1: [Month_/Year]
- From the Dimensions pane, right-click each field, and select Change Data Type > String.
- Select Analysis > Create Calculated Field.
- In the Calculated Field dialog, do the following:
- For the name, type Month/Year.
- Enter the below formula, and click OK.
DATE(RIGHT([Month_/Year], 2) + "-" + LEFT([Month_/Year], 3) + "-" + "01")
Option 2: [FY_Year]
Select Analysis > Create Calculated Field.
In the Calculated Field dialog, do the following:
- For Name, type Year.
- Enter the below formula and click OK.
DATE("01-01-"+[FY_Year])