DateTimeZone.FixedLocalNow is a Power Query M function that returns a datetime value set to the current date and time on the system with local timezone information. The function returns a fixed datetime value that will not change with successive calls.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
DateTimeZone.FixedLocalNow() as datetimezone
datetimezone value set to the current date and time on the system. The returned value contains timezone information representing the local timezone. This value is fixed and will not change with successive calls, unlike DateTimeZone.LocalNow, which may return different values over the course of execution of an expression.
Let’s see an example of the DateTimeZone.FixedLocalNow function. Here’s the output of this function at the moment it was run:
// At the time of running this query the function returns
// #datetimezone( 2023, 7, 23, 14, 12, 29.0738, 2,0)
// represented by: 2023-07-23T14:12:29.0738000+02:00
A function like DateTimeZone.FixedLocalNow returns the
datetimezone value belonging to the machine where a query is run. That means if your dataset refreshes in Ireland while you live in the Netherlands, it returns returns the Irish time.
Other functions related to DateTimeZone.FixedLocalNow are: