#datetimezone Function in Power Query

The #datetimezone function in Power Query is used to create datetimezone values, which combine date, time, and timezone offset information into a single value.

Syntax

#datetimezone(
  year as number, 
  month as number, 
  day as number, 
  hour as number, 
  minute as number, 
  second as number, 
  offsetHours as number, 
  offsetMinutes as number
) as datetimezone     

Example: Let’s create a value of type DateTimeZone.

Power Query M

let
    Source = #datetimezone(2025,2,25,4,45,20,5,30)
in
    Source         

The output of the above code is 25-02-2025 04:45:20 +05:30.