Create column with list of values from another column

[mtrevisiol]

Hi everyone,

I've got a table like this:

I would like to create a third column containing the list of activities (second column) performed by each supplier (first columns). The ideal result is:

How can I do it through a calculated column / dax formula?

here is the link to the PBIX file: https://www.dropbox.com/scl/fi/unfh6jlr97e2hnogyr7lh/Create-column-with-list-of-values-from-another-...

Thank you in advance.

[Ashish_Mathur · Accepted solution]

Hi,

This calculated column formula works

Column = CONCATENATEX(FILTER('Table','Table'[Supplier]=EARLIER('Table'[Supplier])),'Table'[Activity],"|")

[mtrevisiol]

It works! Many thanks

[Ashish_Mathur]

You are welcome.

[vicky_]

List of Activities = CONCATENATEX(FILTER(ALL('Table'), 'Table'[Supplier] = SELECTEDVALUE('Table'[Supplier])), 'Table'[Activity], " | ")

Try adapting the above for your table.