Hi,
I'm trying to convert timezone for a column but I keep getting errored out as below:
Expression.Error: We cannot convert the value #datetime(2021, 6, 4, 10, 0, 0) to type DateTimeZone.
Details:
Value=6/4/2021 10:00:00 AM
Type=[Type]
Formula Used: = DateTimeZone.SwitchZone([Start Time], 0)
Details:
let
Source = Excel.CurrentWorkbook(){[Name="Table4"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{<!-- -->{"Change Request", type text}, {"Start Time", type datetime}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each DateTimeZone.SwitchZone([Start Time], 0))
in
#"Added Custom"


