Text to date format in Query

[Anonymous]

Hi,

I have a table that I have imported using Power Query with a column with dates on the format 201703 ie YYYYMM. It gets stored as text and when I use the function within Query to change type to Date I get the result “2452-04-06”. How can I change the format to date, keeping the right information?

/Helena

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/How-to-change-decimal-number-to-date-format/m-p/225567#M100403