DateTimeZone.LocalNow Function in Power Query

The DateTimeZone.LocalNow function in Power Query returns a DateTimeZone value set to the current system date and time along with the system's timezone offset from UTC.

Syntax

DateTimeZone.LocalNow() as datetimezone

Example:

Power Query M

let
    Source = DateTimeZone.LocalNow()
in
    Source

The output of the above code is 2025-04-11T13:08:32.5926070+05:30.

Key Features

Local System Time: Reflects the current time of the machine running Power Query.
Timezone-Aware: Includes the UTC offset (e.g., -04:00, +05:30).
Dynamic: Updates each time it is called.

Previous Next