Forum Discussion

aishak12's avatar
aishak12
Helper IV
3 years ago
Solved

Date Format MMM-YY

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"?

 

 

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Arul's avatar
    Arul
    3 years ago

    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

1 Reply

  • Arul's avatar
    Arul
    Super User
    3 years ago

    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