First Time Customer List

[Anonymous]

Hello Everyone,

I have a column chart where I show a count of new customers by month with "month year" along the x-axis.

Similarly, I would like to create a matrix/list that shows the name of the new customers in each month (as opposed to count).

Below is an image of what I have already.

I've done a search of the community, but not had much luck with the keywords.

Any tips,

Thanks

Rich

[TomMartens · Accepted solution]

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