First Time Customer List

Hey,

yes it could be done, but some for effort is necessary ...

EXCEPT returns a table, instead of using this as the 1st argument of concatenatex store this into a variable.

Then use something like this

CONCATENATEX(
FILTER(ALL('<customertable>')
, '<customertable>'[customer key] IN tablevariable
)
, concatenate all the column values
, new line separator
)

Hopefully this is what you are looking for.

Regards,
Tom

Hi Anonymous ,

Please try to change the comma to "IN" or other operators.

The syntax of Filter is like below. We need to write a Boolean expression for <filter>. You could reference the document to learn more.

  

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.