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

Hello, try this (dax)

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

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