Convert code YYYYMM to date in PowerQuery

[Pbiuserr]

Hello,

I've got in my calendar only codes like 202201 202202 etc. I'd like to convert them to dates in PowerQuery like:

202201 - 01/01/2022

202202 - 01/02/2022

and so on. Is that possible?

[Pbiuserr · Accepted solution]

= Table.TransformColumns(#"previous step", {{"column name", each _ & "01", type date}})

works

[amitchandak]

@Pbiuserr ,

You can create a new column

Date 1 = #date(Text.Start([date],4), Text.End([date],2),1)

or

= Date.FromText([Date]&"01")

[Pbiuserr]

Hi,

Both functions doesn't work

Expression.Error: We cannot apply operator & to types Number and Text.
Details:
Operator=&
Left=202201
Right=01