DateTime.FixedLocalNow is a Power Query M function that returns a datetime value set to the current date and time on the system, which is fixed and will not change with successive calls.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
DateTime.FixedLocalNow() as datetime
datetime value set to the current date and time on the system. This value is fixed and will not change with successive calls, unlike DateTime.LocalNow, which may return different values over the course of execution of an expression.
Let’s see an example of the DateTime.FixedLocal now function. Here’s the output of this function at the moment it was run:
DateTime.FixedLocalNow() // At the time of running this query the function returns // #datetimezone( 2023, 7, 23, 12, 56, 24.0738740) // represented by: 2023-07-23T12:56:24.0738740
Other functions related to DateTime.FixedLocalNow are: