Convert column from etc to local timezone in Get Data Process

Hi Tango2310 

To convert the datetime column to UTC+10 during data ingestion, you can add a step in the Power Query to adjust the time. You can try:

Add a custom column. You can create a new column and add 10 hours to the existing datetime column.

Use the DateTime.AddZone function. This function helps you convert the date time to a specific time zone.

let
    Source = ...,
    RemovedOtherColumns = Table.SelectRows(Source, each ([crbb0_quotestage] = 252750008)),
    AddedCustom = Table.AddColumn(RemovedOtherColumns, "UTC+10", each DateTime.AddZone([utit_quotefinaliseddate], 10))
in
    AddedCustom

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.