Convert YYYY-MM to date format

[Anonymous]

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.

[Fowmy]

@Anonymous 

Try this please:

#date( Number.From(Text.Start([Column],4)) ,Number.From(Text.End([Column],2)),1)

[Fowmy]

@Anonymous 

You can use this code in Power Query.

[amitchandak · Accepted solution]

@Anonymous , create a new column

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