Forum Discussion
Understanding Expression.Evaluate - isn't working
When you use Expression.Evaulate you need to include every variable and library function you want to make avialable in a record. In your case:
Expression.Evaulte(#"Need Help", [Long Step Name = #"Long Step Name"])
I think you're just holding it wrong. Here's how far I got for now.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WUtJR8krMUzAyMDJQitUB88G0Z0lqLpAdnJiTWgwWSATyDMGsJCDLCMxKBrKMlWJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
#"Long Step Name" = Source,
#"Added Custom" = Table.AddColumn(#"Long Step Name", "Custom", each List.PositionOf(Table.Column(#"Long Step Name","Column1"),"Item"))
in
#"Added Custom"
please ignore the custom column, that's just for debugging.
The next step would be
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WUtJR8krMUzAyMDJQitUB88G0Z0lqLpAdnJiTWgwWSATyDMGsJCDLCMxKBrKMlWJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
#"Long Step Name" = Source,
ToSkip = List.PositionOf(Table.Column(#"Long Step Name","Column1"),"Item"),
#"Removed Top Rows" = Table.Skip(#"Long Step Name",ToSkip),
#"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Sales", Currency.Type}})
in
#"Changed Type"
When you use Expression.Evaulate you need to include every variable and library function you want to make avialable in a record. In your case:
Expression.Evaulte(#"Need Help", [Long Step Name = #"Long Step Name"])Thanks artemus
So in the Final step below, Expression.Evalute doesn't know what to evaluate, and I have to tell it where Long Step Name is defined?Why am I saying:
Long Step Name = #"Long Step Name"
Is "Long Step Name" how Evaluate.Expression sees it, and #"Long Step Name" is the reference to the step?let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WUtJR8krMUzAyMDJQitUB88G0Z0lqLpAdnJiTWgwWSATyDMGsJCDLCMxKBrKMlWJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]), #"Long Step Name" = Source, #"Need Help" = Expression.Identifier("Long Step Name") & "[" & Table.ColumnNames(#"Long Step Name"){0} & "]", Final = Expression.Evaluate(#"Need Help", [Long Step Name = #"Long Step Name"]) in FinalYes, you are binding the object to the name it currently is known as.
The second parameter to Evaluate is the environment (which is optional). If you don't include the parameter then your statement cannot refer to any outside variables, or any standard functions like List.Max, the only calls you can make are the constructor for table, date, time, datetime, datetimezone, duration.
If you wanted to be able to reference all previous steps you would have to enumerate all of them in the record. If you wanted to include all top level objects you could use #shared, but if you use this, Power Bi will refuse to load it into the model due to security reasons.
Ex:
Expression.Evaulate("foo + List.Max([bar])", [foo = 9, _ = [bar = {1, 2, 7, 5}]], List.Max = each _{List.Count(_) - 1})
would evaulte to:
14, since foo = 9, and List.Max is bound to a function which returns the last element in a list (5), instead of the max of the list.
