Forum Discussion

New Member

3 years ago

How can I turn this column into a date type with a mm-yyyy format on power query?

I want to turn this column into a date type in power query but keep the month-year format. How can I achieve this on power query?

Super User

3 years ago

You cannot. If you want the date displayed like that in the Power Query UI, you will have to set the data type to text and use a formula like:

Table.TransformColumns(#"Previous Step",{"Column Name", each Date.ToText(_,"MM-yyyy"), type text})

Unlike Excel (or Power BI), Power Query does not have a separate formatting option for data.

Helper II

1 year ago

Legend, looked everywhere for a solution to this, and it's exactly what I needed!

Gave kudos as well.