Forum Discussion
Post ProdigyYYYYMM integer code to DD/MM/YYYY date in PQ/DAX
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
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
2 Replies
evandrocunicoResolver III
Hello, try this (dax)
NewDate = DATE(MID(202207,1,4),MID(202207,5,2),"01")
- goncalogeraldes
Super User
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