A dynamic value is a value that takes into account your personal settings, resulting in potentially different values for each user. The M Language offers a limited selection of dynamic values to cater to varying user environments.
Available Dynamic Values
Power Query offers the following dynamic values:
| Argument | Description |
|---|---|
| Culture.Current | Returns the name of the current culture for the application. |
| DateTime.FixedLocalNow | Returns the current date and time in the local timezone |
| DateTime.LocalNow | Returns the current date and time in the local timezone. |
| DateTimeZone.FixedLocalNow | Returns the current date & time in the local timezone |
| DateTimeZone.FixedUtcNow | Returns the current date and time in UTC (the GMT timezone) |
| DateTimeZone.LocalNow | Returns the current date & time in the local timezone. |
| DateTimeZone.UtcNow | Returns the current date and time in UTC (the GMT timezone). |
| TimeZone.Current | Returns the name of the current time zone for the application. |
