Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Format date from text

I have a column that has years in YYYY text format. I want to convert it to date format (YYYY) Here are the steps that I carried out: 1. I change the data type of the column to text. Let's call thi...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    If your year column is of text type like 2017, 2018, 2019,

    just convert the data type to number.

    You could use it in the x-axis of a chart.

     

    If you want to create a column like 2017/1/1, 2018/1/1, 2019/1/1

    Just add a custom column

    Text.Combine({Text.From([year], "en-US"), "1/1"}, "/")

    Then convert the data type to date.

     

     

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous  - I don't think you can convert a year to date format. Why does it need to be in date format?

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
Nathan Peterson
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous  it needs to be in YYYY format because the cell values are results from a test that is done once every year.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      It is already in YYYY format, so I don't understand what else you want to do?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Anonymous  I should have been more clear. Currently, the date is in text format. I would like to convert it into YYYY date format and build bar graphs with x-axis as years 2013, 2014, 2015,....