How to fix a date formatting error

[ZiaAnderson]

I have a MonthYear column. Data comes from CSV like this:

When the column type changes from text to date, it turns into this:

How can I turn it into "date", but preserve the Month-Year formatting? 

Thank you!

[ppm1 · Accepted solution]

Before you change to type, add a replace values step and replace "-" with "-1-", and then change to Date.

Pat

[ZiaAnderson]

Genius! What didn't i think of that? 🙂 Thank you.

[ZiaAnderson]

I tried the first option. 

1. If I keep it as text, I cannot use it as a date picker in my report.

2.  Not sure how to use DAX in my Power Query. Is there a way to format in the same step where the data type changes? Because formatting after the "Change Type" step doesn't make sense - the date is already wrong.

[vicky_]

By default, it will show as dd-mm-yy. I think there are two options - create a duplicate column and keep that as a text format, or use the FORMAT function in DAX to format the output of any measures you want to display.