Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Date format error

Hi,    Probably a stupid question but here it goes.    From a SQL database I am trying to get some dates imported into Power BI Desktop, the date format is yyyymmdd, when I am trying to transform...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    You cam convert to text first and to date next (in a separate step).

     

    Example:

     

    let
    Source = 20170312,
    #"Converted to Table" = #table(1, {{Source}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type text}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type",{{"Column1", type date}})
in
    #"Changed Type1"
MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

You cam convert to text first and to date next (in a separate step).

 

Example:

 

let
    Source = 20170312,
    #"Converted to Table" = #table(1, {{Source}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type text}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type",{{"Column1", type date}})
in
    #"Changed Type1"