DateTimeZone.RemoveZone is a Power Query M function that removes timezone information from a datetimezone value. The function returns a #datetime value without timezone information.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
DateTimeZone.RemoveZone( dateTimeZone as nullable datetimezone ) as nullable datetime
The DateTimeZone.RemoveZonetakes a
datetimezone value as its input and returns a
datetime value. This function is particularly useful when you’re dealing with data that includes
timezone information, but you want to standardize or simplify the data by removing this information. The returned
datetime value is identical to the original
datetimezone value, but without any
Let’s delve into a example to better understand how the DateTimeZone.RemoveZone function works.
Suppose you’re analyzing a dataset that includes timestamps from different timezones. To simplify your analysis, you might want to remove the timezone information and just work with the dates and times. Here’s how you can do it:
// Output: #datetime(2023, 12, 31, 9, 15, 36) DateTimeZone.RemoveZone( #datetimezone( 2023, 12, 31, 9, 15, 36, -7, 0 ) )
This function call will convert the datetimezone value “2023-12-31T09:15:36-07:00” into the datetime value “2023-12-31T09:15:36”, effectively removing the timezone information.
Other functions related to DateTimeZone.RemoveZone are: