Forum Discussion
Power Query - Replace Formula Operator with Parameter
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!
i did not get your point, and why your original code cannot get what you want?
Hey,
I wanted to start with a simple example to see if I could take that and apply it to my more complex example. The simple version works but for some reason the more complex example doesn't. The error I'm getting says it's expecting ',' somewhere.
I'll breakdown the formula:
COUNT OF DELIMITERS: List.Count( Text.ToList(Text.Select([campaign_name], #"01a: DV360 Campaign Name Delimiter")))
REPLACE WITH PARAMETER: =
TARGET DELIMITERS: List.Count(#"01a: DV360 Campaign Names Fields")-1
Does that help?
Text.From(List.Count( Text.ToList(Text.Select([campaign_name], #"01a: DV360 Campaign Name Delimiter"))))&ParameterValue&Text.From(List.Count(#"01a: DV360 Campaign Names Fields")-1)
is this ok?
Hey,
It throws up errors with the following:
put those into Expression.Evaluate