LOAD * Month(IncidentDate) as Month, Year(IncidentDate) as Year, Date(IncidentDate,'MMM-YY') as MonthYear
However, when I do so using the above script it looks like it is converting each individual date into a MonthYear value, with lots of duplicates. You can see the issues pretty clearly in the attached chart.
Any suggestions? I tried to use MonthStart because I read somewhere that that would help eliminate the duplicates, but then the calculation didn't work at all (null values).
Date(MonthStart(IncidentDate,'MMM-YY')) as MonthYear