expression.evaluate - import a snippet .not the whole script

ghdunn,

Add Let expression and see code below.

let #"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if [country] = "USA" then 1 else if [country] = "UK" then 2 else 3) in #"Added Conditional Column"

Expression.Evaluate(Source2, Record.Combine({[#"Changed Type"=#"Changed Type"], #shared}))

ghdunn,

Change it as follows.

    Result = Expression.Evaluate(
in
    Result