Forum Discussion
Power Query - Replace Formula Operator with Parameter
Hi, I want to replace the operator in one of my power query formulas with a parameter, so I can adjust the formula without having to go into Power Query to find the step and update it manually. ...
Success, it works!
Here's the final code:
Expression.Evaluate(Text.From(List.Count( Text.ToList(Text.Select([line_item], #"01c: DV360 Line Item Delimiter - Display"))))&#"01a: DV360 LI Exact or Minimum"&Text.From(List.Count(#"01c: DV360 Line Item Fields - Display")-1),[_=_])Thanks so much for your help!
= Table.AddColumn(#"Campaign: Taxonomy Match Indicator", "Custom", each if Expression.Evaluate("[total_impressions]"&ParameterValue&"100",[_=_]) then "YES" else "NO")