OpenBI Docs Buy

DateTime.FixedLocalNow

The computer's date and time, read once and then the same for the whole evaluation.

Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.

Syntax

DateTime.FixedLocalNow() as datetime

It takes no parameters.

Returns

datetime. The local date and time when the clock was first read.

Remarks

  • Every call during one evaluation gives the same moment, so rows stamped with it all agree. DateTime.LocalNow reads the clock again at each call.

Examples

Now, once

DateTime.FixedLocalNow()
#datetime(2026, 11, 8, 15, 42, 28)

Two calls agree

DateTime.FixedLocalNow() = DateTime.FixedLocalNow()
true

DateTime.LocalNow, DateTimeZone.FixedLocalNow, DateTimeZone.FixedUtcNow.

Last updated · OpenBI Studio 0.3.79