Forum Discussion

alexb's avatar
alexb
New Member
8 years ago
Solved

Date string

Hi,

 

I'm importing a csv file with dates in this format: "Jan 1, 2017 6:01:12 AM PST". How do i transform these text strings to actual dates in PowerBI when importing?

 

Thanks.

3 Replies

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion
    8 years ago
    let
    Source = "Jan 1, 2017 6:01:12 AM PST",
    #"Converted to Table" = #table(1, {{Source}}),
    #"Extracted Text Before Delimiter" = Table.TransformColumns(#"Converted to Table", {{"Column1", each Text.BeforeDelimiter(_, " PST", 0), type text}}),
    #"Parsed Date" = Table.TransformColumns(#"Extracted Text Before Delimiter",{{"Column1", each Date.From(DateTimeZone.From(_)), type date}})
in
    #"Parsed Date"