Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Date Format mmm-yy in Power Query (M-Language)

Hi,

 

Is there any way to transform a date format of dd-mm-yyyy to mmm-yy without changing this data to a text format in Power Query Editor in Excel (M-Language)?

 

Best Regards


Samuel

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous 

    Not sure there is a way... But what if you keep the date column as is and just add a new column with way you would want the date formatted?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Nick,

       

      Yeah it is possible. I was only looking for a direct solution for this issue

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI Anonymous ,

    >>Is there any way to transform a date format of dd-mm-yyyy to mmm-yy without changing this data to a text format in Power Query Editor in Excel (M-Language)?

    AFAIK, format function can change display date format, but it will also modify you column type. You can consider change this field display format on data model side.

    Regards,

    Xiaoxin Sheng