Date Format MMM-YY

[aishak12]

All,

I have this date column and I am trying to format it into MMM-YY, so I can create a monthly average visual.

I tried using this calculated column and I'm unable to change the format to "Date". For some reason it goes straight to "Text". How can I keep it as "date"?

[Arul · Accepted solution]

@aishak12 ,

try this,

1. Create this calculated column and change the date format to like the below (refer the attached image)

Month Year = 
VAR _month = MONTH('Date'[Date])
VAR _year = YEAR('Date'[Date])
VAR _result = _month &"-"& _year
RETURN DATEVALUE(_result)

2. Result:

Thanks,

Arul