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

[Anonymous]

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

[v-shex-msft]

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

[Anonymous]

@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]

Nick,

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