DateTimeZone.SwitchZone Function in Power Query
The DateTimeZone.SwitchZone function in Power Query changes the timezone information for the input DateTimeZone.
Syntax
DateTimeZone.SwitchZone( dateTimeZone as nullable datetimezone, timezoneHours as number, optional timezoneMinutes as nullable number ) as nullable datetimezone
Example:
Power Query M
let
// Step 1: Create a table with datetimezone values
Source = Table.FromRecords({
[Name = "Ashish", CreatedAt = #datetimezone(2025, 4, 10, 8, 30, 0, 3, 30)],
[Name = "Ravi", CreatedAt = #datetimezone(2025, 4, 10, 12, 45, 0, 5, 30)],
[Name = "Neha", CreatedAt = #datetimezone(2025, 4, 10, 14, 0, 0, 2, 0)]
}),
// Step 2: Remove Timezone from DateTimeZone value
ZoneRemoved = Table.AddColumn(Source, "TransformedOutput", each DateTimeZone.SwitchZone([CreatedAt], 1,30), type datetimezone)
in
ZoneRemoved The output of the above code is shown in the image below:
