Forum Discussion
Solved
Using list in parameter in M language
Hi, I have a list of orderid in my repot. then i have a anohter query pull data based on this list. here is my M language for using this list as in statement: WHERE #(lf) WEBORDERNUM IN("...
One method:
To put single-quotes around each item in the list, change
Text.Combine(List,",")
to
Text.Combine( List.Transform(List, each "'"&_&"'"), ",")
Regards,
Owen
One method:
To put single-quotes around each item in the list, change
Text.Combine(List,",")
to
Text.Combine( List.Transform(List, each "'"&_&"'"), ",")
Regards,
Owen