Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
Proud to be a Datanaut!
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}})
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
Proud to be a Datanaut!
This worked, thank you so much Pete!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.