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 | Input | Output |
|---|---|---|---|
| Culture.Current | A dynamic value in the Power Query M language that returns the name of the current culture for the application. | Text | |
| TimeZone.Current | A dynamic value in the Power Query M language that returns the name of the current time zone for the application. | Timezone | |
| DateTime.FixedLocalNow | Returns the current date and time in the local timezone | DateTime | |
| DateTime.LocalNow | Returns the current date and time in the local timezone. | DateTime | |
| DateTimeZone.FixedLocalNow | Returns the current date & time in the local timezone | DateTimeZone | |
| DateTimeZone.FixedUtcNow | Returns the current date and time in UTC (the GMT timezone) | DateTimeZone | |
| DateTimeZone.LocalNow | Returns the current date & time in the local timezone. | DateTimeZone | |
| DateTimeZone.UtcNow | Returns the current date and time in UTC (the GMT timezone). | DateTimeZone | |
| Module.Versions | Returns a record of module versions for the current module and its dependencies. | Record | |
| TimeZone.Current | Returns the name of the current time zone for the application. | Text |
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy