Forum Discussion
Applicable88
Impactful Individual
Impactful IndividualHow to convert number format like 202104 into date in PowerQuery M?
Hello,
I want to convert 202104 into a a date format. How do I extract those numbers to make month and year of it?
Thanks.
Best.
Try a new column in M
=#date(Number.FromText(Text.Start([Column],4)) ,Number.FromText(Text.End([Column],2)),1)
1 Reply
- amitchandak
Super User
Try a new column in M
=#date(Number.FromText(Text.Start([Column],4)) ,Number.FromText(Text.End([Column],2)),1)