Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power Query: Remove TimeZone info

hi,   When I use this in my Power Query:     [createdon] + #duration(0,10,0,0)   I get a value that is returned as type 'Any'. The value looks like :   4/08/2018 6:45:24 AM +00:00   ...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

 

Regards,

Daniel He

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

    Thanks for getting back to me.

     

    Not resolved.

     

    At the moment I have a long winded bunch of steps that will split a text date time field by the '+' delimiter and then remove the rest of the unwanted columns - hardly an elegant solution.

     

       #"Added CreatedOnAEST" = Table.AddColumn(#"Changed Type", "CreatedOnAEST", each if DSTQuery([CreatedOnUTC]) = 1 then [createdon] + #duration(0,10,0,0) else [createdon] + #duration(0,11,0,0)),
    #"Split Column by Delimiter" = Table.SplitColumn(Table.TransformColumnTypes(#"Added CreatedOnAEST", {{"CreatedOnAEST", type text}}, "en-AU"), "CreatedOnAEST", Splitter.SplitTextByDelimiter("+", QuoteStyle.Csv), {"CreatedOnAEST.1", "CreatedOnAEST.2"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"CreatedOnAEST.1", type datetime}, {"CreatedOnAEST.2", type time}}),
    #"Removed Columns1" = Table.RemoveColumns(#"Changed Type1",{"CreatedOnAEST.2"}),
    #"Renamed Columns1" = Table.RenameColumns(#"Removed Columns1",{{"CreatedOnAEST.1", "CreatedOnAEST"}})
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      So is it possible to put this in a function and then call it Power Query?