DateTime.LocalNow Function in Power Query
The DateTime.LocalNow function in Power Query returns a datetime value set to the current date and time on the system.
Syntax
DateTime.LocalNow() as datetime
Example:
Power Query M
let Source = DateTime.LocalNow() in Source
The output of the above code returns the current local date and time in the power query desktop. And if it triggers in the power query online it returns the current UTC date and time.