Converting Number to Date - met with error

[Anonymous]

Hi all,

 Apologies if this specific instance has been answered before but I couldn't find the problem when I searched the forums.

I have imported an excel spreadsheet into Power BI to make a simple report, and I am trying to convert the following column from a number to a date 

However, when I go to Change Type -> Date it gives me the following error:

Would anyone have any idea why this is? 

Thanks!

[AlexisOlson]

Power Query understands this format if you're converting from text but not from an integer, so another approach is to transform the column like this:

Table.TransformColumns(#"Prev Step", {{"assignment_start", each Date.From(Text.From(_)), type date}})

[BA_Pete · Accepted solution]

Hi @Anonymous ,

Try this in a new custom column:

#date(
    Number.From(Text.Start(Text.From([assignment_start]), 4)),
    Number.From(Text.Range(Text.From([assignment_start]), 4, 2)),
    Number.From(Text.End(Text.From([assignment_start]), 2))
)

I get the following output:

Pete

[Anonymous]

This worked, thank you so much Pete!