How to convert number format like 202104 into date in PowerQuery M?

[Applicable88]

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. 

[amitchandak · Accepted solution]

@Applicable88 ,

Try a new column in M

=#date(Number.FromText(Text.Start([Column],4)) ,Number.FromText(Text.End([Column],2)),1)