DateTimeZone.RemoveZone Function in Power Query
The DateTimeZone.RemoveZone function in Power Query returns a datetime value with the zone information removed from the input datetimezone value.
Syntax
DateTimeZone.RemoveZone(dateTimeZone as nullable datetimezone) as nullable datetime
Example: Let’s remove the timezone information.
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.RemoveZone([CreatedAt]), type datetimezone)
in
ZoneRemoved The output of the above code is shown in the image below:
