Concatenate column with a row identifier

[hasarinfareeth]

Hi 

I have the data source as below in which I need to concatenate a specific column based on the row identifier.  Can you please help me in acxhiving this through DAX?

S No	Name	Purchased Item
1	Sam	Cloth
2	Chris	Food
1	Sam	Gift
3	Peter	Shoes
2	Chris	Tickets
4	Dean	Flowers
3	Peter	Candy

Expected Result:

S No	Name	Purchased Items - Concatenated
1	Sam	Cloth, Gift
2	Chris	Food, Tickets
3	Peter	Shoes, Candy
4	Dean	Flowers

[DataInsights · Accepted solution]

@hasarinfareeth,

Try this measure:

Purchased Items - Concatenated = 
CONCATENATEX ( SUMMARIZE ( 'Table', 'Table'[S No], 'Table'[Purchased Item] ), 'Table'[Purchased Item], ", " )

[divyed · Accepted solution]

Hello @hasarinfareeth ,

Use below dax for your purpose :

This will be slightly better in performance than SUMMERIZE.

GROUPBY

This function works similarly to SUMMERIZE , but instead of calculating aggregations, it just groups by the specified columns. Since you're not performing any aggregation (like summing or counting), GroupBY can be more direct and semantically cleaner in this context.

Purchased Items - Concatenated =

CONCATENATEX (

    SUMMARIZE (

        'Table',

        'Table'[SNO],

        "ConcatenatedItems",

        CONCATENATEX (

            FILTER (

                'Table',

                'Table'[SNO] = EARLIER('Table'[SNO])

            ),

            'Table'[Purchased_Item],

            ", "

        )

    ),

    [ConcatenatedItems],

    ", "

)

I hope this helps.

Did I answer your query ? Mark this as solution if this helps.

Warm Regards,

Neeraj Kumar

[DataInsights · Accepted solution]

@hasarinfareeth,

Try this measure:

Purchased Items - Concatenated = 
CONCATENATEX ( SUMMARIZE ( 'Table', 'Table'[S No], 'Table'[Purchased Item] ), 'Table'[Purchased Item], ", " )