Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to fix a date formatting error

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 ...
Need Help
  • ppm1's avatar
    ppm1
    3 years ago

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

     

    Pat

vicky_'s avatar
vicky_
Super User
3 years ago

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.