Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Convert YYYY-MM to date format

Hi Epxerts

 

I want to convert date in text format from 2019_01 into 01 Jan 2019 in Power Query. 

Data Examples

2019_01

2019_02

 

where the second part is the month

i have tried

1. Add Column - Custom Column

2. Type = Date.From("01-" & [Column])

 

and no luck.

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , create a new column

     

    Date = date(left([column],4), right([column],2), 1)

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , create a new column

     

    Date = date(left([column],4), right([column],2), 1)

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

    Try this please:

    #date( Number.From(Text.Start([Column],4)) ,Number.From(Text.End([Column],2)),1)
    • Fowmy's avatar
      Fowmy
      Super User
      5 years ago

      Anonymous 

      You can use this code in Power Query.