Dynamic Values Overview

Updated on

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:

ArgumentDescription
Culture.CurrentA dynamic value in the Power Query M language that returns the name of the current culture for the application.
TimeZone.CurrentA dynamic value in the Power Query M language that returns the name of the current time zone for the application.
BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/dynamic-values
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.