Forum Discussion
Pbiuserr
Post Prodigy
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...
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
evandrocunico
Resolver III
Resolver IIIHello, try this (dax)
NewDate = DATE(MID(202207,1,4),MID(202207,5,2),"01")