YYYYMM integer code to DD/MM/YYYY date in PQ/DAX

[Pbiuserr]

Hello,

I have codes such as

202201

202207

which represents year 2022 and respective month where 01 is january, 07 is july etc.

I would like to change them to represent date for the first of that month so

202201 - 01/01/2022

202207 - 01/07/2022

Ideally in power query, may be in dax also

Thank you in advance for your help

[evandrocunico · Accepted solution]

Hello, try this (dax)

NewDate = DATE(MID(202207,1,4),MID(202207,5,2),"01")

[goncalogeraldes · Accepted solution]

Hello there @evandrocunico ! If you need it in PQ you can do the following:

= Table.AddColumn(Previous_Step, "Column_Name", each Text.Combine({"01/", Text.Middle([Date_Column], 4), "/", Text.Start([Date_Column], 4)}), type date)

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[evandrocunico · Accepted solution]

Hello, try this (dax)

NewDate = DATE(MID(202207,1,4),MID(202207,5,2),"01")