Expression.Evaluate
This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.
Evaluates a Text expression and returns the evaluated value.
Expression.Evaluate(expression as text, optional environment as [...]) as any
| Argument | Description |
|---|---|
| expression | The expression to evaluate. |
| optional environment | The expression environment. |
Expression.Evaluate("1 + 1") equals 2
Expression.Evaluate("1 +") equals Error
Expression.Evaluate(
"section Section1; shared X = 1;"
) equals Error, only expressions are supported
Expression.Evaluate(
"Record.Field([A=1], ""A"")"
) equals error. Unknown identifier "Record.Field".
Expression.Evaluate(
"Record.Field([A=1], ""A"")",
[Record.Field = Record.Field]
) equals 1
let
x = 1
in
Expression.Evaluate("x") equals Error. Unknown identifier "x".
let
x = 1
in
Expression.Evaluate(
"x",
#shared
) equals Error. Unknown identifier "x".
let
x = 1
in
Expression.Evaluate("x", [x = x]) equals 1
section;
shared MyText = "ABC";
MyResult = Expression.Evaluate(
"Text.StartsWith(MyText, ""A"")",
#shared
); // true
section;
MyText = "ABC";
MyResult = Expression.Evaluate(
"Text.StartsWith(MyText, ""A"")",
#shared
); equals Error. Unknown identifier "MyText" (since MyText isn't shared).