topic Re: I am looking to create an aggregated / consolidated table with unique rows based on a table with multiple rows for the same dimension in App Development

I am looking to create an aggregated / consolidated table with unique rows based on a table with multiple rows for the same dimension

sashak — Mon, 30 Jun 2025 20:14:06 GMT

I am looking to create a table with unique rows, where values in one column, are concatenated into a string with the comma separator. See screenshots for reference.

Original table:

Account	Account Manager
Agency 1	Jane Smith
Agency 1	John Baker
Agency 1	Jason Green
Agency 1	Catherine Blake
Agency 5	Jessica Carter
Agency 6	Keven Wiess

Table to create:

Account	Account Manager
Agency 1	Jane Smith, John Baker, Jason Green, Catherine Blake
Agency 5	Jessica Carter
Agency 6	Keven Wiess

Appreciate any suggestions.

Re: I am looking to create an aggregated / consolidated table with unique rows based on a table with multiple rows for the same dimension

seanbruton — Mon, 30 Jun 2025 22:24:11 GMT

Hi,

Please try this. Make your Account Manager Column a measure and use concat function with a distinct.

concat(distinct [Account Manager],',’ )

Regards

Sean

Re: I am looking to create an aggregated / consolidated table with unique rows based on a table with multiple rows for the same dimension

sashak — Tue, 01 Jul 2025 13:50:24 GMT

Thank you, @seanbruton ! That worked.

Re: I am looking to create an aggregated / consolidated table with unique rows based on a table with multiple rows for the same dimension

seanbruton — Tue, 01 Jul 2025 13:57:32 GMT

@sashak I am happy it's resolved. Please could you mark the correct answer as the solution.