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 "D...
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

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