Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Issue converting date to MMM-YY

I have a date column which I want to convert to MMM-YY format. I used this formula:    = left(format(month([Date]),"mmmm"),3) & "-" & right(Year([Date]),2)   But for some reason, all the columns...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI Anonymous ,

     

    You can try this.

     

    YYYY-MON = FORMAT(Table[Date],"YYYY-MM")

     

    else in Power Query create a custom Column

     

    =Number.ToText(Date.Year([Date]))&"-"&Number.ToText(Date.Month([Date]))

     

    Regards,
    Harsh Nathani
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

     

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi Anonymous ,

 

Try creating a column like this:

newCol = FORMAT(ClothingSales[Date],"mmm-yy")
 
Just use your column name in the above DAX.
 
Thanks,
Pragati